Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 304528 - Last Review: April 3, 2007 - Revision: 5.4
Database opens for shared use even after you have set the default open mode option to exclusive
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).
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.
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.
If you have the
Default open mode set to
Exclusive, click
Open in the
Open dialog box instead of
Open Exclusive.
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.
Steps to Reproduce the Behavior
- Start Access, and then open a database.
- On the Tools menu, click Options.
- In the Options dialog box, click the Advanced tab.
- Under Default open mode, click Exclusive, and then click OK.
- Quit and then restart Access.
- On the File menu, click Open.
- In the Open dialog box, select a database.
- Click the arrow next to the Open button, and then click Open Exclusive.
- On the Tools menu, point to Security, and then click Set Database Password.
- 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.
APPLIES TO
- Microsoft Office Access 2003
- Microsoft Access 2002 Standard Edition
| kbopenfile kbprb KB304528 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate