Whether you're trying to change the password of an Access database or adjust other security settings, Access 2013 might remind you to open the database in Exclusive Mode. If you need to do that, this article will give you details on how to enable Exclusive Mode.
Steps
-
Open Microsoft Access 2013. Assuming you have it installed, you'll find this program on your computer either in your Start menu or on your Start screen.
- On Windows 10, you can type "Access 2013" into the Cortana search box in the bottom left corner of the taskbar/screen to the right of the Start menu icon. Click "Access 2013" when it pops up.
-
Select Open. If the program was closed before, you'll see an area that says "Recent"; you can click the "Open Other Files" button in the maroon-red bar on the left of the screen.
- For quick access to other areas to open Access database files from, you can press the keyboard shortcut for Open by using the shortcut Ctrl + O .
Advertisement -
Find the file, but don't click the Open button just yet. Access 2013 makes it easy to peruse your file structure, and gives you one-click access to OneDrive files separate from local database files. You can select your search folder and single-click your file from the menu. You can highlight the file, but don't open it all the way just yet.
-
Look closely at the Open button (you'll be clicking a little later). You'll notice that the word Open isn't the only thing on this Open button. There is also a drop-down arrow on it, to the right of the vertical bar that splits the button off.
-
Click the drop-down arrow that is shown. Don't click where it says open, but do click the area to the right of the vertical bar.
-
Scroll down and click either "Open Exclusive" or "Open Exclusive Read-Only" and select it.
- You can't make changes to database information in "Read-Only" mode, but can make security changes that will stick after saving.
- "Open Exclusive" is used for those who want to make high-end security changes and edit the data or tables, at the same time.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Warnings
- Opening a file in Exclusive Mode is like opening a file that is under lock-and-key. Ensure you have gotten your administrator's permission, if you need permission to open it this way.Thanks
Advertisement
About this article
Thanks to all authors for creating a page that has been read 23,479 times.
Advertisement
