Articles Office How to Lock MS Access Database with password

lock ms access

How to Lock MS Access Database with password

If there are some important and private data on your Access Database, you can lock the database file with password to prevent unauthorized people from opening and viewing it. Following this article will show you how to password protect Access Database 2016, 2013, 2010, 2007.

Tips:

To set or remove Access database password, you must have the database file open for Exclusive use. How to open the Access database exclusively, follow the detail steps below.

open database for exclusive use

Password protect Access database
Option 1: Protect Access Database 2013/2016 with password
Option 2: Lock Access Database 2010 with password
Option 3: Password protect Access Database 2007

Option 1: Protect Access Database 2013/2016 with password

1. Open your Access Database file with Microsoft Access 2013/2016 program.

2. Click on File > Open > Browse.

d

3. Select your Access database file, click on the arrow next to Open, and then select "Open Exclusive", to open your Access database file exclusively.

select open exclusive

4. Click on File > Info > Encrypt with Password.

encrypt access 2016 with password

5. Enter password, and enter password again to verify it, then click on OK.

And then your Access database file is protected with password, the next time whoever want to open it, will need to enter this password.

set database password

Option 2: Lock Access Database 2010 with password

1. Open your Access database file with MS Access 2010 program.

2. Click on File > Open.

3. Navigate to your Access DB file location, and select the database file, click on the arrow next to Open, and then select "Open Exclusive".

open access 2010 exclusively

4. Click on File > Info option, and then select Encrypt with Password.

encrypt access 2010 db with password

5. Type in the protected password, verify it, and then click on OK. Then this database file is encrypted, and it must be opened with password from now on.

Option 3: Password protect Access Database 2007

1. Open your Access DB file with MS Access 2007 program.

2. Click on the Folder icon on the left-top corner. And then on the Open dialog, select you DB file, click on the arrow next to Open, and select Open Exclusive.

open access 2007 db exclusively

3. On the Menu bar, click on Database Tools, and then click on Encrypt with Password.

encrypt access db 2007

4. Enter and reenter the protected password, then click on OK to put password on your Access database file.

Tips: When have made your Access database password protected, you will need to open it with this password. If you forgot this Access database file password, you won't be able to open and gain access to this Access database file. So, please remember to write down the encrypted password and keep it in a secure place.

If want to decrypt your Access database, see this article: remove access database protected password.

Besides to lock Access database with password, you also can set password to lock Windows screen to prevent unauthorize people from accessing your Computer.

Related Articles