You receive a "The Database Will Be Opened Read-Only" error message when users try to open a project or extension file in a multiuser environment (318868)

The information in this article applies to:

Microsoft Access 2002

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 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:	Minor	Last Reviewed:	8/10/2004
Keywords:	kbDatabase kberrmsg kbprb KB318868