How To Remove Access Database Password

Removing the Database Password

You can remove the password you have set for a database. Once a password
is set, the choice in the Tools, Security menu choice becomes Unset
Database Password. You will be prompted for the password; it is case-sensitive.
After you remove the database password, anyone has access to the database.

Let's remove the database password you set for databasename.mdb

Removing a database password.

1. Close databasename.mdb. Open databasename.mdb in Exclusive Mode.



2. Enter dbpassword. Click OK


3. Choose Tools, Security, Unset Database Password.
   Notice how this command has a different name now that the database
   has a password set on it.


4. In the Password text box, type dbpassword.
   
   


5. Click OK to accept the password and close the dialog box.



6. Let's test this change. Close the database.


7. Open databasename.mdb. You didn't need to enter a
   database password to open the database.