Interactive Tutorial
How to Password Protect a Database in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
You can encrypt a database using a password to keep unauthorized users from opening the database.
To encrypt a database, you first need to open it in Exclusive mode.
The database opens in Exclusive mode. Now we can encrypt it with a password.
The Set Database Password dialog box appears.
The password is set. In the future, whenever anyone tries to open the database, they will first be prompted to enter a password.
You can remove a password at any time.
The password is removed from the database.