Log In

Password Protect a Database

How to Password Protect a Database in Access

Access Training

Access Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Password Protect a Database

You can encrypt a database using a password to keep unauthorized users from opening the database.

Set a Password

To encrypt a database, you first need to open it in Exclusive mode.

  1. Click the File tab on the ribbon.
    Set a Password
  2. Select Open.
  3. Click Browse.
    Set a Password
  4. Browse to and select the Access file you want to encrypt.
  5. Click the Open list arrow and select Open Exclusive.
    Set a Password

    6. The database opens in Exclusive mode. Now we can encrypt it with a password.

  6. Click the File tab.
    Set a Password
  7. Click Encrypt with Password.
    Set a Password

    The Set Database Password dialog box appears.

  8. Type a password in the Password field, enter it again in the Verify field, and click OK.
    Set a Password

The password is set. In the future, whenever anyone tries to open the database, they will first be prompted to enter a password.

Remove a Password

You can remove a password at any time.

  1. Open the encrypted database in Exclusive mode.
  2. Click the File tab.
    Remove a Password
  3. Click Decrypt Database.
    Remove a Password
  4. Type a password in the Password field and click OK.
    Remove a Password

The password is removed from the database.

You Get:
  • LinkedIn-ready certificate
  • Skill assessments
  • Bite-sized, interactive lessons
  • Saved progress