MS Access 2007: Open the database exclusively
This MSAccess tutorial explains how to open the database exclusively in Access 2007 (with screenshots and step-by-step instructions).
See solution in other versions of Access:
Question: In Microsoft Access 2007, I tried modifying some of the objects in my Access database and I received an error message stating that I needed to open the database exclusively. What does this mean and how do I open a database exclusively?
Answer: Because Access was designed to accommodate multiple users in the system at the same time, you may need to have exclusive access to the database to modify forms, tables, etc. depending on the circumstances.
To open an Access database exclusively, launch Microsoft Access. Click on the Microsoft Office button 
in the top left of the Access window and then click on the Open option.
Select the database that you wish to open exclusively. Click on the arrow to the right side of the Open button. A list of options will appear (Open, Open Read-Only, Open Exclusive, Open Exclusive Read-Only).
Select "Open Exclusive" from the list.
Your Access database will open. In this case, we've chosen an Access database called Testing2.accdb.
Advertisements