You are currently offline, waiting for your internet to reconnect

Database opens for shared use even after you have set the default open mode option to exclusive

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q304528
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS
When you have set Default open mode to Exclusive on the Advance tab of the Options dialog box, and you then open a database by clicking Open Exclusive in the Open dialog box, Microsoft Access opens the database for shared use.
CAUSE
If you set Default open mode to Exclusive, and you then click the arrow to the right of the Open button in the Open dialog box, you see that the Open Exclusive option has a check mark next to it. When you then click this item, the check mark is cleared. This causes the database to open in shared mode.
RESOLUTION
If you have the Default open mode set to Exclusive, click Open in the Open dialog box instead of Open Exclusive.
STATUS
This behavior is by design. When you click the down arrow next to the Open button in the Open dialog box, the items in this list act as if they are toggle buttons. If an item already has a check mark next to it, when you click it again, the check mark is cleared. If an item does not have a check mark next to it and you click it, the item will be checked.
MORE INFORMATION

Steps to Reproduce the Behavior

  1. Start Access, and then open a database.
  2. On the Tools menu, click Options.
  3. In the Options dialog box, click the Advanced tab.
  4. Under Default open mode, click Exclusive, and then click OK.
  5. Quit and then restart Access.
  6. On the File menu, click Open.
  7. In the Open dialog box, select a database.
  8. Click the arrow next to the Open button, and then click Open Exclusive.
  9. On the Tools menu, point to Security, and then click Set Database Password.
  10. Note that you receive the following error message. This error message indicates that the database has been opened in shared mode.
    You need to have the database open for exclusive use to set or unset the database password.

    To open the database exclusively, close the database, and then reopen it using the Open command on the File menu. In the Open dialog box, click the arrow to the right of the Open button, and the choose Open Exclusive.
shared exclusive ACC2002 ACC2003
Properties

Article ID: 304528 - Last Review: 04/03/2007 19:37:54 - Revision: 5.4

  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • kbopenfile kbprb KB304528
Feedback