Article ID: 136140
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q136140
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you start Microsoft Access on a network workstation, you may receive the following error messages:
-and-
CAUSE
Microsoft Access was installed on a network server with the Workdir folder set to Read-Only.
RESOLUTION
Make sure that all Microsoft Access users have at least Read and Write permissions for the Workdir folder. The first user to run the Microsoft Access Wizards also needs Create permissions so that Microsoft Access can create the associated .ldb files. After the .ldb files are created, the users will no longer require Create permissions unless any of the users have Delete permissions for the Workdir folder. This is because of the new automatic creation and deletion behavior of .ldb files in Microsoft Access.
NOTE: You need to explicitly give Create permissions for Novell networks.
For more information about .ldb files in Microsoft Access 95 and Microsoft Access 97, please see the following article in the Microsoft Knowledge Base:
136128 ACC: Introduction to .ldb Files (95/97)
If your operating system does not allow you to have a single read/write folder of a read-only shared folder, make the Microsoft Access program folder read/write, but make all the files in the Microsoft Access program folders (except for the Workdir folder) read-only.
For more information about permissions needed for the Workdir folder, refer to the Netwrk8.txt file, which is located in the Office folder on the Microsoft Office 97 Service Release 1 CD. This file is also copied to the server during an administrative installation of Microsoft Office 97 Service Release 1.
MORE INFORMATION
When you start Microsoft Access on a network workstation, you must have Write permissions for the following files in the Workdir folder on the server.
For more information about permissions needed by the Workdir folder, please see the following article in the Microsoft Knowledge Base:
167172 OFF97: Workdir Needs Add'l Permissions for Workstation Install
In Microsoft Access 97
System.mdw, Wizard.srg, Wzcnf80.mda, Wzdat80.mdt, Wzlib80.mde,
Wzmain80.mde, and Wztool80.mde (the wizard files)
In Microsoft Access 95
System.mdw, Wd95acc.tlb, Wzdat70.mdt, Wzlib70.mda, Wzmain70.mda,
and Wztool.mda (the wizard files)
NOTE: The Utility.mda file is installed in the parent folder of the Workdir folder (whether this is an Office install or Microsoft Access install) and should be read-only.
To verify that the problem you are having is caused by incorrect permissions for the Workdir folder, try using a supervisory-level logon to start Microsoft Access on the workstation.
REFERENCES
For more information about installing Microsoft Access on a network, search the Help Index for "shared databases," and then "share a database on a network," or ask the Microsoft Access 97 Office Assistant.
Additional query words: permissions rights
Keywords: kbinfo kbsetup KB136140
