If forgot Microsoft Access Database password how you can open and unlock it? On Access 2003 minimizing versions, Microsoft supply the code to unlock mdb database password in 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. Which means you are prompted to keep the password inside a secure place when setting a password in your accdb database.
However, if unfortunately, you forgot the accdb encrypted password, what to do?
Part 1: Recover your Access Database Password
It is simple and simple for you to recover your Access database password having a tool.
Step 1: To begin 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 begin Access Password Tuner when finish the installation.
Step 2: Click on Open button.
Step 3: Select your Access database file to import in.
Step four: Select a type of attack from the drop-down list, and adjust the settings.
Step five: Click Start button and also the recovery process will start!
Tips: The recovery time depends on the complexness of the password, and also the attack type you decide on.
Step six: After a while your password is recovered, it will likely be showed around the box below. Copy the password, and paste it to unlock your Access database password.
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 a steps below.
Step 1: Open the accdb file on Access with password, click on File, and click on Open.
Step 2: Choose the accdb file that you simply want to decrypt, click on the drop-down list beside Open, and select “Open Exclusive”.
If need, go into the password on the text box again.
Step 3: Click on File, and then click on Decrypt Database.
Step 4: On the Unset Database Password dialog, go into the password, and then click OK.
Now your Access database password continues to be removed, and you may open it without typing password the next time.
Part 3: Unlock mdb database password with VBA code
If you work with the lower version of Access, such as Access 2000, you can unlock it without software, using the code on Visual Basic of Application.
Step 1: Produce a new Access Database, and open it.
Step 2: Press Alt + F11 to open the Visual Basic of Application.
Step 3: Click Insert → Module.
Step four: Go into the code on General window.
Tips: Remember to change the database file road to yours.
Step 5: Press F5 to run it. After some time, if go successfully, your locked mdb file will be unlocked without password.