As a reminder, it is critical that you remember your password — if you forget your password, there is no method by which it can be retrieved.
Step 1: Select the Microsoft access database file that you want to open and choose Open Exclusive.
Step 2: Once you select the encrypted access database and are ready to open it in Microsoft Access. A dialog would pop up to ask for database open password.
Step 3: Type database password in Enter database password box. Click OK.
Step 4: Remove a password from a database
When you remove a password from a database, you can restore it at any time (or replace it with another password) by repeating the steps in our post about How to Encrypt an Access Database.
Go to the File->Info section and select Decrypt Database.
After prompting you for the current password one last time, all encryption will be removed and your database will no longer require a password to open.