ACC97: Error Messages Running Database Documenter or Table Analyzer (164240)



The information in this article applies to:

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

This article was previously published under Q164240
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

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.

When you receive the "Subscript out of Range" error message, Microsoft Access does not close in the conventional manner; you must press CTRL+ALT+DEL to end the task.

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.

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.

Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kberrmsg kbnetwork KB164240 kbAudDeveloper