Microsoft KB Archive/318868

= You receive a &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: 318868

Article Last Modified on 8/10/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q318868



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

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

For a Microsoft Access 2000 version of this article, see 322762.



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 kbdatabase kbprb KB318868

-

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

© Microsoft Corporation. All rights reserved.