ACC: Add-ins, Wizards and Builders Need Read\Write Permissions

• Microsoft Access versions 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

After installing an add-in, wizard, or builder and setting the permissions or file attributes to Read-Only, you may receive the following error message.

In Microsoft Access 97

Microsoft Access can't find the Wizard, or there is a syntax error in the Declarations section of a Visual Basic Module.

-or-

This feature isn't installed. To install this feature, rerun the Microsoft Access or Microsoft Office setup program, click Add/Remove, and then click the Advanced Wizards check box.

In Microsoft Access 95

Microsoft Access can't start the wizard, builder, or add-in.

-or-

This feature isn't installed. To install this feature, rerun the Microsoft Access or Microsoft Office setup program, click Add/Remove, and then click developer tools."

CAUSE

The add-in, wizard, or builder has the Read-Only file attribute set and/or does not have Read\Write permissions.

RESOLUTION

Make sure that the file attributes for all add-ins, wizards, and builders are not Read-Only and that they have Read\Write permissions.

MORE INFORMATION

If the component you are using does not append, update, or delete data in any of the tables it may contain, it is possible to set a reference to it from within a database, and then access functions and procedures within the component.

This is the case even when the file does not have Read\Write permissions or if the Read-Only attribute has been set. However, you must first uninstall the component as an add-in, wizard, or builder.

To add a reference to a component or library, follow these steps:

1. Open the database in which you want to use the component.



2. In the Database Window, click the Modules tab.



3. Select any module and click Design, or if no modules exist in the Modules window, click New.



4. On the Tools menu, click References.



5. In the Add References box, click Browse, and then in the Files Of Type box, select the type of component you want to reference.



6. In the Look In box, locate the component, and then click OK.



7. Click OK to close the References dialog box.

REFERENCES

For more information about wizards, please see the following articles in the Microsoft Knowledge Base:

Q162358 ACC95: Err "Access Can't Find the Wizard" (Workstation Setup)

Q167172 OFF97: Workdir Needs Add'l Permissions for Workstation Install

Additional query words: prb add ins

Keywords : WzHowto
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbprb