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: | Minor | Last Reviewed: | 1/26/2005 |
|---|
| Keywords: | kbbug kberrmsg kbnetwork KB164240 kbAudDeveloper |
|---|
|