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

• Microsoft Access 7.0

SYMPTOMS

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

When you try to use a Microsoft Access 7.0 wizard with a network (workstation) setup of Microsoft Access 7.0, you may receive one of the following error messages:

   This feature isn't installed.

   -or-

   Microsoft Access Can't Find the Wizard or there is a syntax error in
   the declaration section of the Visual Basic module.

   ARTICLE-ID: Q162357
   TITLE     : ACC95: Err "Microsoft Access Can't Find the Wizard" (Local
               Setup)

CAUSE

There are several possible causes for these errors:

• You have read-only permissions for the Workdir folder.
• A wizard database file is missing.
• A type library file is missing or misregistered.
• A file needed to run the wizards is mismatched or corrupted.

RESOLUTION

Each of the possible causes has its own resolution. If you are unsure what is causing the error, try each resolution in order and check to see if the wizard is fixed after each one.

You Have Read-Only Permissions for the Workdir Folder

If you run Microsoft Access 7.0 on a network, you must have both Read and Write permissions for the Workdir folder on the network server; under certain circumstances, you may also need Create permission.

For more information about user privileges required for the Workdir folder, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q136140
   TITLE     : ACC95: Privileges Needed for Workdir Folder

A Wizard Database File Is Missing

If you still receive an error message when you are logged on to your workstation as a network administrator or supervisor, verify that Workdir is not a read-only folder. Also verify that the following files exist in the Workdir folder, and that the read-only attribute is not set for any of them:

   Msau7032.dll
   Wd95acc.tlb
   Wzcnf70.mda
   Wzdat70.mdt
   Wzlib70.mda
   Wzmain70.mda
   Wztool.mda

A Type Library File Is Missing or Misregistered

Search your hard drive for the file Dao2532.tlb. The file is set up by default in the \Program Files\Common Files\Microsoft Shared\Dao folder (for Microsoft Windows 95) or in the \Winnt\Msapps\Dao folder (for Microsoft Windows NT version 3.51). In Microsoft Windows NT version 4.0 the file may be in either folder, depending on how the operating system was installed.

If You Find Dao2532.tlb on Your Computer:

Run the Setup program with a command-line option that resets the Windows Registry settings for Microsoft Access:

1. In Microsoft Windows 95 or Windows NT version 4.0, click the Start button on the taskbar, and then click Run.

   In Microsoft Windows NT 3.51, in Program Manager or File Manager, click Run on the File menu.

2. Type a command to run the Setup program using the /y switch, for example:

         <Drive>:\setup /y
   

   Replace <Drive> with the drive letter for your network server.

3. In the Installation Maintenance dialog box, click Reinstall.

4. When the Setup program is finished, start Microsoft Access and try to run the wizard.

Rerun the Setup program and reinstall Microsoft Access 7.0:

1. Close all applications, including the Microsoft Office toolbar.

2. Start the Setup program.

   In Microsoft Windows 95 or Windows NT 4.0:

         a. Click the Start button on the taskbar, point to Settings, and
            then click Control Panel.
   
         b. In Control Panel, double-click Add/Remove Programs.
   
         c. In the Add/Remove Programs Properties dialog box, click Microsoft
            Access 7.0 or Microsoft Office Professional, and then click
            Add/Remove.
   
      In Microsoft Windows NT 3.51:
   
         a. Open the program group for Microsoft Access or Microsoft Office.
   
         b. Double-click the Setup icon.
   
   

3. In the Installation Maintenance dialog box, click Reinstall.

4. When the Setup program is finished, start Microsoft Access and try to run the wizard.

A File Needed to Run the Wizards Is Mismatched or Corrupted

Once you determine that none of the previous steps resolve the error message you receive when you try to run a wizard, you must remove and reinstall Microsoft Access for Windows 95 or Microsoft Office Professional for Windows 95.

The Setup program will not remove any Microsoft Office files that you created from your hard drive. However, it is strongly recommended that you back up any Microsoft Office files that are important to you before you follow these steps.

1. Remove all Microsoft Access for Windows 95 or Microsoft Office Professional for Windows 95 Setup files from the network server.

2. Recreate the Setup files on the network server by running an Administrative installation on the server.

3. Verify that the Workdir folder on the server has the correct permissions.

4. Delete the following files from the Windows System folder on your workstation's hard drive if they exist.

   NOTE: If you are using Windows Explorer, click Options on the View menu and verify that the Show All Files option is selected. Without that option, you may not see these files if they exist on your hard drive.

         Msjetsql.tlb
         Msjint32.dll
         Msjt3032.dll
         Msjter32.dll
         Msrd2x32.dll
         Mswng300.dll
         Vaen232.dll
         Vba232.dll
         Vbajet32.dll
         Vbar2232.dll
         Ven2232.olb
   

5. Delete the \Program Files\Common Files\Microsoft Shared\Dao folder (for Microsoft Windows 95) or the \Winnt\Msapps\Dao folder (for Microsoft Windows NT version 3.51 or 4.0) on your workstation's hard drive if it exists.

6. Rerun the Setup program from your network server and reinstall Microsoft Access for Windows 95 or Microsoft Office Professional for Windows 95 on your workstation.

7. Start Microsoft Access and start the wizard.

REFERENCES