ACC2000: "The Database Will Be Opened Read-Only" Error Message When Users Try to Open a Project or Extension File in a Multiuser Environment (322762)

The information in this article applies to:

Microsoft Access 2000

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 DatabaseName 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

Modification Type:	Major	Last Reviewed:	6/25/2004
Keywords:	kberrmsg kbprb KB322762