Articles Office How to Lock MS Access Database with password

How to Lock MS Access Database with password

Updated: By Yvonne Keller

lock ms access

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
Tips: Simply Encrypt Access Database Documents Using File Lock Tuner

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.

Tips: Simply Encrypt Access Database Documents Using File Lock Tuner

There is a much easier way to password protect Access Database file no matter you are using Access Database 2016,2013,2010,or 2007. Cocosenor File Lock Tuner can help you to lock the Access Database file within simple clicks.

Step 1: Run Cocosenor File Lock Tuner on your computer. If you do not have it installed on your computer, download and finish the installation firstly.

Step 2: Click the file icon on the software and then add the Access DB file into your computer. If you have a series of such files to password protect, you can click the folder icon and then choose those files to import.

click to add Access Data

Step 3: Check the Access DB file and then set the password to encrypt it. Afterwards, hit the Encrypt button to continue.

select file and set the password

Step 4: In minutes, the Access DB file is encrypted successfully.

encrypt access database successfully

Now you can head to the original folder and find there is a new XEP file with the same file name. Yes, it is the password protected Access Database file, which cannot be opened and viewed now.

check the encrypted nfile

To keep your data secure, you can delete the original file. If you want to open, view and edit the data, you can apply the Decrypt function of File Lock Tuner to unlock the file.

Related Articles