Microsoft KB Archive/322762

= ACC2000: &quot;The Database Will Be Opened Read-Only&quot; Error Message When Users Try to Open a Project or Extension File in a Multiuser Environment =

Article ID: 322762

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q322762



This article applies only to a Microsoft Access project (.adp).

Moderate: Requires basic macro, coding, and interoperability skills.

For a Microsoft Access 2002 version of this article, see 318868.



SYMPTOMS
When users in a multiuser environment try to open a Microsoft Access project (.adp) file or a Microsoft Access project extension (.ade) file, they may receive an error message similar to the following:

The database  will be opened read-only because one of the following occurred: The file is locked for editing by another user, or the file (or the folder in which it is located) is marked as read-only, or you specified that you wanted to open this file read-only.



CAUSE
This behavior is by design. An Access project is strictly a client and has no multiuser capability.



RESOLUTION
To resolve this issue, deploy a copy of the .adp file or .ade file to each computer.

For information about how to deploy Microsoft Access project solutions, browse to the following MSDN articles:

Developing Client/Server Solutions with Microsoft Access 2000 Projects

http://msdn.microsoft.com/library/en-us/dnapg/html/apgintro.asp

Creating and Deploying Access Solutions with the Microsoft Data Engine

http://msdn.microsoft.com/library/en-us/dnacc2k/html/msdedeploy.asp

Additional query words: prb

Keywords: kberrmsg kbprb KB322762

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.