Microsoft KB Archive/103254
Article ID: 103254
Article Last Modified on 1/18/2007
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q103254
Moderate: Requires basic macro, coding, and interoperability skills.
When you open multiple instances of a Microsoft Access database, even though multiuser options have been set, you may receive the following error message.
In Microsoft Access 7.0 and 97:
In Microsoft Access versions 1.x and 2.0:
This problem can occur if you try to open a shared database by choosing it from the list at the bottom of the File menu instead of using the Open Database command on the File menu. When you open a database by choosing it from the bottom of the File menu, Microsoft Access opens the database with the same settings as the last time it was opened. If that database was last opened in Exclusive mode, clicking it from the bottom of the File menu will attempt to open it again in Exclusive mode, even if your Default Open Mode option is set to Shared.
This problem will also occur when the database is on a read-only drive and the first user to open the database has Read rights to the folder.
Running a single instance of Microsoft Access, open that particular database with the Open Database command on the File menu. Then close the database, thereby saving the correct settings to the database.
Steps to Reproduce Behavior
This problem occurs when Microsoft Access is being shared on a network, but can be reproduced on a stand-alone computer with the following steps:
- Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0) by clicking Open Database on the File menu. Click to select the Exclusive check box, and then click Open.
- On the Tools menu, click Options.
NOTE: In versions 1.x and 2.0, on the View menu, click Options.
- Click the Advanced tab and set the Default Open Mode to shared.
NOTE: In versions 1.x and 2.0, the Default Open Mode is in the Multiuser/ODBC settings.
- Quit Microsoft Access.
- Restart Microsoft Access, and then open the sample database Northwind.mdb by selecting the database from the bottom of the File menu.
- Start a second instance of Microsoft Access.
- Open the sample database Northwind.mdb by clicking Open Database on the File menu. Note that you receive the error message.
Additional query words: UI recent couldn t
Keywords: kberrmsg kbprb KB103254