Microsoft KB Archive/164240

= ACC97: Error Messages Running Database Documenter or Table Analyzer =

Article ID: 164240

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 97 Standard Edition
 * Microsoft Office 97 Professional Edition
 * 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.

