Database opens for shared use even after you have set the default open mode option to exclusive (304528)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
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.
Modification Type: | Minor | Last Reviewed: | 6/9/2004 |
---|
Keywords: | kbopenfile kbprb KB304528 |
---|
|