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. Error message when you try to open an Access project file or an Access project extension file in a multiuser environment: "The Database Will Be Opened Read-Only"

Error message when you try to open an Access project file or an Access project extension file in a multiuser environment: "The Database Will Be Opened Read-Only"

View products that this article applies to.

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/ ) .
For a Microsoft Access 2000 version of this article, see 322762� (http://support.microsoft.com/kb/322762/ ) .
For a Microsoft Access 2002 version of this article, see 318868� (http://support.microsoft.com/kb/318868/ ) .
For a Microsoft Access 2000 version of this article, see 322762� (http://support.microsoft.com/kb/322762/ ) .

↑ Back to the top

Symptoms

When you try to open a Microsoft Access project (.adp) file or a Microsoft Access project extension (.ade) file in a multiuser environment, you may receive the following error message:
The Microsoft OfficeAccess project ProjectName 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

The file may be locked for editing by another user, or the file or the folder where it is located may be marked as read-only. This behavior is by design. A Microsoft Access project is strictly a client application and has no multiuser capability.

↑ Back to the top

Workaround

To work around this issue, deploy a copy of the .adp file or the .ade file on each computer.

For information about how to deploy Microsoft Access project solutions, visit the following Microsoft Developer Network (MSDN) Web sites:
http://msdn2.microsoft.com/en-us/library/aa139953(office.10).aspx

http://msdn2.microsoft.com/en-us/library/aa140041(office.10).aspx

↑ Back to the top

References

For more information about .ade files, click the following article number to view the article in the Microsoft Knowledge Base:
278376� "Make MDE File" or "Make ADE File" command is not available in Access 2002

↑ Back to the top

Keywords: KB824266, kbprb, kberrmsg, kbdatabase, kbopenfile

↑ Back to the top

Article Info
Article ID : 824266
Revision : 4
Created on : 6/1/2007
Published on : 6/1/2007
Exists online : False
Views : 391