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:

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

   ARTICLE-ID: Q167172
   TITLE     : OFF97: Workdir Needs Add'l Permissions for Workstation
               Install