Microsoft KB Archive/117912

= ACC2: User Needs Read/Write Permissions for WORKDIR Folder =

Article ID: 117912

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q117912



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you start Microsoft Access on a network workstation, you may receive the following error messages:

Could not open SYSTEM.MDA

  -and-

Can't find SYSTEM.MDA

Or, you receive the following compile error messages while Microsoft Access is loading the add-ins:

Compile time error

  -and-

Tried to load module with duplicate procedure name



CAUSE
Microsoft Access was installed on a network server with the WORKDIR directory set to Read-Only.



RESOLUTION
Make sure that all Microsoft Access users have at least Read and Write permissions for the WORKDIR directory.

Within some network environments, it may also be necessary to give users Create permissions, especially when using Microsoft Access for the first time. This would allow Microsoft Access to create the SYSTEM.LDB file within the WORKDIR directory.



MORE INFORMATION
When you start Microsoft Access on a network workstation, you must have write permissions for the following .MDA files in the WORKDIR directory on the server: SYSTEM.MDA, WZLIB.MDA, WZTABLE.MDA, WZBLDR.MDA, WZFRMRPT.MDA, and WZQUERY.MDA (the Wizard files). The UTILITY.MDA file is installed in the parent directory of the WORKDIR directory (whether this is an Office install or Microsoft Access install) and should be read-only.

To verify that the error messages are caused by incorrect permissions set for the WORKDIR directory, follow these steps:


 * 1) Set the attributes for the WORKDIR directory (not just the individual files) to Read/Write.
 * 2) Use a supervisory-level login to start Microsoft Access on the workstation.

