Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: "The Database Will Be Opened Read-Only" Error Message When Users Try to Open a Project or Extension File in a Multiuser Environment

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

View products that this article applies to.

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� (http://support.microsoft.com/kb/318868/EN-US/ ) .

↑ Back to the top

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.

↑ Back to the top

Cause

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

↑ Back to the top

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/en-us/library/aa139953.aspx
Creating and Deploying Access Solutions with the Microsoft Data Engine
http://msdn.microsoft.com/en-us/library/aa140041.aspx

↑ Back to the top

Keywords: KB322762, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 322762
Revision : 4
Created on : 6/25/2004
Published on : 6/25/2004
Exists online : False
Views : 292