It is always a good idea to password-protect or encrypt a database especially if it contains some secret information. Encrypting or password protecting a database helps to ensure that the database is secured to prevent malicious intruders from gaining access into the database, thereby ensuring data security. It is always a good advice to first learn how to decrypt or unprotect a database before you encrypt a database. Protecting a database is the process of shielding or securing a database from unauthorized users or persons with a secret code known as password.

How to secure and password protect a database in MS Access

This is part 2 of chapter 8 of the Free Online Access Tutorial Series at Microsoft Tutorial website. In this part, I will explicitly explain how password-protect and unprotect a database in MS Office Access.

In the previous part (Part 1) at http://www.microsofttut.com/2017/04/step-by-step-guides-to-create-macro-in-ms-access.html, I explained how to create embedded and standalone macros in any versions of MS Access in detail. Also see the full tutorial course content of this Microsoft Access Tutorial Series at http://www.microsofttut.com/2017/04/how-to-design-professional-reports-in-ms-excel.html.

HOW TO PASSWORD PROTECT A DATABASE IN MS ACCESS
Below are the step by step guide to secure a database in Microsoft Access with a password.

To Password-protect a Database in MS Access:
1. Load MS Access into your pc memory. Close the database if it already open. Then click File > Open. This prompts the Open dialogue box.

2. Specify the location of the database you wish to open and select the database name.

3. Click the drop down menu beside the Open button and select Open Exclusive from the resulting options as shown below. Access opens the database in exclusive mode.

Select open exclusive

NOTE:

The above three steps are used to open a database in exclusive mode.
4. Click the File tab and then click Encrypt with Password. Optionally, you can add the Set Database Password command icon in the Quick Access toolbar, where it will be easily accessible.


5. To add the Set Database Password command icon to the Quick Access tool bar: click the File tab > Options. From the Access Options dialogue box, click Quick Access tool bar from the extreme left section of the dialogue box. Then click the Choose command from: drop down menu and select Commands Not in the Ribbon option from the resulting menu list. Then select Set Database Password from the sub-options and click the Add >> button to put it in the Quick Access tool bar. Finally click Ok as shown below.

Select set database password and click add

MS Access adds the Set Database Password command icon to the Quick Access toolbar.

NOTE:

You can further customize the Quick Access toolbar by adding some frequently used command in it simply by selecting the command from the Access Options dialogue box.

6. Click the Set Database Password command icon from the Quick Access toolbar located above the tab bar as shown below.

Select set database password icon from the quick access tool tab

7. This prompts the Set Database Password dialogue box. Type in the password you wish to use to secure the database and re-type it for verification. Then click OK. A warning dialogue box displays. Click Ok to exit it.

Type a password and confirm it

So anytime you or anyone else try to open this database, MS Access will demand for the password. Make sure you use a code you are very familiar with so that you won’t forget it.

HOW TO UNPROTECT MS ACCESS DATABASE (REMOVING THE PASSWORD)
For some reasons, you might want to change or remove (decrypt) the password from a database you previously password-protected. Un-protecting a database is the process of removing or un-setting a database password. Note that you must first open a protected database before you can be able to un-protect it. This means that you must know the password of the protected database before you can remove the password. You can also change the database password using the procedure below.

To Remove or Change A Database Password:
Click http://www.microsofttut.com/2017/04/step-by-step-guides-to-encrypt-decrypt.html to study full tutorials with screen to screen images.