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:
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.
Additional query words: rights Microsoft Access can t find the wizard
Keywords: kbbug kberrmsg kbnetwork KB164240
