Since I posted to this thread before, I feel a responsibility (admittedly minute) to see it through.
The Microsoft idea is to allow varying capabilities in forms and reports (front end) by user. So, the design is to give each user their own .ADP/.ADE. When you do that with the appropriate shortcut so only one user accesses a given .ADP/.ADE, they won't receive a read-only message.
Note there are threads here in Tek-Tips illustrating methods to roll out new versions of files.
Reference the following two Microsoft Knowledgebase articles:
318868-ACC2002: "The Database Will Be Opened Read-Only" Error Message When Users Try to Open a Project or Extension File in a Multiuser Environment
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
Creating and Deploying Access Solutions with the Microsoft Data Engine
-------------------------------------------------------
322762-ACC2000: "The Database Will Be Opened Read-Only" Error Message When Users Try to Open a Project or Extension File in a Multiuser Environment
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
Creating and Deploying Access Solutions with the Microsoft Data Engine