Articles Office How to Unlock Your Access Database If Forgot Password

unlock access

How to Unlock Your Access Database if Forgot Password

If forgot Microsoft Access Database password how to open and unlock it? On Access 2003 and lower versions, Microsoft provide the code to unlock mdb database password from the Visual Basic for Applications. But on Access 2007 and higher edition, Microsoft can't help you to find back the protection password after you forgot or lost it. So you are prompted to store the password in a secure place when setting a password on your accdb database.

However, if unfortunately, you forgot the accdb encrypted password, what to do?

Guide Steps
Part 1: Recover your Access Database Password
Part 2: Remove password from your MS Access database
Part 3: Unlock mdb database password with VBA code

Part 1: Recover your Access Database Password

It is simple and easy for you to recover your Access database password with a tool.

Step 1: To start Access Password tool.

1.1 Download Cocosenor Access Password Tuner, and install it on the computer where you are going to recover Access Database password.

1.2 Select to start Access Password Tuner when finish the installation.

Step 2: Click on Open button.

click on open button

Step 3: Select your Access database file to import in.

Step 4: Select a type of recovery from the drop-down list, and adjust the settings.

select type of attack

Step 5: Click Start button and the recovery process will begin!

click on start button

Tips: The recovery time depends on the complexity of your password, and the recovery type you select.

Step 6: After a while your password is recovered, it will be showed on the box below. Copy the password, and paste it to unlock your Access database password.

database file password is recovered

Part 2: Remove password from your MS Access database

After recovering your accdb password, you can use it to open the database file from Microsoft Access easily. If don't need the password anymore, you can remove it from your Access database following the steps below.

Step 1: Open the accdb file on Access with password, click on File, and click on Open.

click on open

If you click on Decrypt Database directly, you will get the massage like the picture below.

get the hint to open exclusive

Step 2: Select the accdb file which you want to decrypt, click on the drop-down list beside Open, and select "Open Exclusive".

select open exclusive

If need, enter the password on the text box again.

enter password on text box

Step 3: Click on File, and then click on Decrypt Database.

click decrypt database

Step 4: On the Unset Database Password dialog, enter the password, and click on OK.

enter password to unset database password

Now your Access database password has been removed, and you can open it without typing password the next time.

Part 3: Unlock mdb database password with VBA code

If you are using the lower version of Access, such as Access 2000, you can unlock it without software, with the code on Visual Basic of Application.

Step 1: Create a new Access Database, and open it.

Step 2: Press Alt + F11 to open the Visual Basic of Application.

Step 3: Click on Insert → Module.

insert a module

Step 4: Enter the code on General window, see the picture below:

enter vba code on the general box

Tips: Remember to change the database file path to yours.

Step 5: Press F5 to run it. And after a while, if go successfully, your locked mdb file will be unlocked without password.

Related Articles