Specify whether an Access database opens in shared or exclusive mode by default
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
This procedure affects the way a Microsoft Access database is opened only on your computer. It does not affect the default for users on other computers.
On the Tools menu, click Options.
Click the Advanced tab.
If you want others to be able to open the Access database at the same time you have it open, click Shared.
If you want sole access to the Access database when you have it open, click Exclusive.
Notes
When you open an Access database in a multiuser environment, you can open it in exclusive and/or read-only mode, even if you specify shared mode by default. For more information, click aa167537(v=office.10).md.
If you set up security in your multiuser environment, you can ensure that users don't open an Access database exclusively by denying them Open Exclusive permission for the database. For more information on removing permissions, click aa159350(v=office.10).md.
When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file.