Password Protecting an Access Database

Password-protecting an Access database secures your sensitive data from prying eyes. This method of security encrypts the database using a master password that you set, so even if the password isn't specified when the database is opened, the data can't be viewed through alternative methods. The use of password encryption governs Microsoft Access 2010 and newer versions. If you are using an earlier version of Access, read Password Protecting an Access 2007 Database.

Difficulty: Easy

Time Required: 10 minutes

Here's How:

  1. Open the database that you wish to password protect in exclusive mode. From the Open dialog box, click the downward arrow icon to the right of the button. Choose "Open Exclusive" to open the database in exclusive mode, which does not allow for other users to make simultaneous changes to the database.
  2. When the database opens, go to the File tab and click the Info button.
  3. Click the Encrypt with Password button.
  4. Choose a strong password for your database and enter it in both the Password and Verify boxes in the Set Database Password dialog box, as shown in the image above. Click OK.

Your database will encrypt.This procedure may take a while depending on the size of your database. The next time you open your database, you'll be prompted to enter the password.

Tips:

  1. Choose a strong password for your database. It should contain both uppercase and lowercase letters, digits and symbols.
  1. If you lose your password, your data cannot be easily recovered. Use a secure password manager or other tool to record the database password if you think you might forget it.
  2. In Access 2016, user-level security is no longer offered, although you can still set a database password.
  3. You can also remove a password using this procedure.

    What You Need:

    • Microsoft Office 2010 or newer
    • Database in ACCDB Format