Facing issue to open Access database just because it is password protected? Don’t get worried, as in this article I have come with some instant fixes to recover Access Database Password.
So just check out the automated solution to get you out of this problematic situation of a locked Access database.
Access Database Password:
MS Access application facilitates its users with the option to set up password so as to protect Access database from copying or being modified by any other user.
So by keeping your database in compatibility password mode you can save your database file. But this also covers a risk if you forget the password.
Maintaining security and privacy must be everyone’s priority after seeing the raising rates of hack attempts. Always set long and complex passwords that no one can easily guess.
If you are in a situation where you forgot your assigned password then go through the fixes mentioned in this post.
How To Recover Access Database Password?
Trick 1# Remove The Password
Open the database first and then remove the password previously assigned in it.
Go through the complete step to perform this task:
Step 1: Open your accdb file first and then tap to the File > Open tab.
step 2: If you directly make a click on the Decrypt Database option then you will receive the following error message:
Step 3: choose the accdb file from which you want to remove the password. Hit the arrow sign present across the Open option this will open the drop-down list. From this list, you have to choose the Open Exclusive option.
Step 4: You are asked to enter the password again in the text box. so assign it and click the ok button.
Step 5: Hit the File tab and from there choose the Decrypt Database option.
Step 6: After that, you will see a dialog box of Unset Database Password will get open on your screen. Enter the password in it and click the ok button.
Now you will see that your database password is been removed. So when the next time you try to open your database, you don’t need to assign any password.
Trick 2# : Unlock Database Using VBA Code
If you are a user of an older access database version then by using the VBA code you can easily recover Access database password.
Go through the complete procedure very carefully.
Step 1: Make a new Access Database and then open it.
Step 2: hit the Alt + F11 button from your keyboard. This will open the Visual Basic Application window.
Step 3: Hit the Insert tab and then Module option.
Step 4: in the general window you have to copy-paste the following code. Just like it is shown in the image:
Dim db As Database
Dim ws As WorkSpace
Dim rst As Recordset
Set ws = DBEngine.WorkSpaces(0)
Set db = ws.OpenDatabase _ (“C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb”, _ False, False, “MS Access;PWD=northwind”)
Set rst = db.OpenRecordset(“Customers”, dbOpenDynaset)
If rst.RecordCount > 0 Then
Tips: don’t forget to change the database file path as per yours.
Step 5: Press the F5 button to run this code.
Now you will see that your locked MDB file is been unlocked without any password.
In this article, I have tried my best to emphasize the perfect solution to unlock password-protected Access database.
Do try all the fixes and share your experiences with us.