ACC97: Error Messages Running DB Documenter or Table Analyzer

• Microsoft Access 97
• Microsoft Office 97 Professional Edition
• Microsoft Office 97 Developer Edition

SYMPTOMS

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

When you perform a Workstation installation of Microsoft Office 97 Professional Edition or Microsoft Access 97 from a network server, you may receive one of the following error messages when you run the Database Documenter or the Table Analyzer Wizards in Microsoft Access:

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

   Subscript out of Range.

CAUSE

This problem occurs because Microsoft Access is running the Database Documenter and the Table Analyzer Wizards from the \Office folder on the server rather than from the \WorkDir folder. Users must have permission to modify the Wzmain80.ldb file in the \Office folder, and permission to create it if it does not already exist. Users also need permission to modify the Wzmain80.mde file in the \Office folder.

RESOLUTION

Grant the necessary permissions for users to create and modify the Wzmain80.ldb file in the \Office folder on the server.

Grant the necessary permissions for users to modify the Wzmain80.mde file in the \Office folder on the server.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The first user may be able to run the wizard successfully, but until that user quits Microsoft Access, any other user may receive an error message when attempting to run the Database Documenter or Table Analyzer Wizards.

REFERENCES

For more information about installing Microsoft Access on a network file server, refer to the \Office\Netwrk8.txt file on your Microsoft Access 97 or Microsoft Office 97 Professional Edition compact disc.