Articles Office Remove Password from Access Database to Open It without Password

remove password

Remove Password from Access Database to Open It without Password

How to open password protected Access database without password? The normal way is removing the protected password from the Access file. If you forgot the Access database password, how to open it?

enter database password

You can open the encrypted Access database with VBA code. Or recover the forgotten password with a professional tool, and then open it with the recovered password.

Guide Steps
Normally remove password from access database
Recover Access database forgotten password
Open password protected Access database with VBA code

Normally remove password from access database

Here this article only takes Access 2016 as example, to get more detail for Access 2013/2010/2007/2003/2000, go and see how to remove MS Access database protected password.

1. Open Access program, and then navigate to File > Open > Browse.

open access database

2. On the Open dialog, select your Access database file, click on the triangle next to open, and then select "Open Exclusive" on the drop-down list.

open access database exclusively

3. Enter the encrypted password, and then click on OK to open the Access database exclusively.

enter database password to open it

4. On Access program, navigate to File > Info, click on "Decrypt Database".

decrypt database

5. Enter the decrypt password, and click on OK to unset Database password.

unset database password

And then your Access database is unprotected, and you can open it without password later on.

However, if forgot password, how to open Access database and remove password from it? You can recover db/accdb password, and then open the database file with the recovered password. How to recover Access database forgotten password? Go to the next part.

Recover Access database forgotten password

If you lost your Access database password, Microsoft can't help you to recover the password. But, you can get help with the third-party Access password recovery tool, like Cocosenor Access Password Tuner. And here will take this program as example to show you how to recover your Access database lost password efficiently.

Step 1: Get the password recovery program - Cocosenor Access Password Tuner, and install it.

Step 2: Click on "Open", and select your db/accdb file to import into the program.

import access file

Step 3: Select an appropriate recovery type, and adjust the recovery settings to speed up the password recovery process.

configure attack settings

Step 4: Begin Access database password recovery by clicking on "Start" buttonstart to recover access database password .

During the process, you can do anything on your PC, such as working or watching movie.

Step 5: Waite for the password recovery process to complete, when the password is recovered, it will be showed on the pop-up box. And then you can open your Access database with the password and remove password from Access database following part 1.

Open password protected Access database with VBA code

This way only works on lower version of Access 2000-2007, if you are using Access 2010-2013, go and see part 2.

To open password protected Access database with VBA code:

Step 1: Create a new Access database without password protected.

Step 2: Open the new mdb file, and press "Alt + F11" to open Microsoft Visual Basic for Application.

Step 3: On the menu bar, click on "Insert", and then select "Module".

Step 4: Copy the following VBA code, and paste it on the module.

Sub OpenDB()
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
rst.MoveLast
MsgBox rst!CustomerID
End If
rst.Close
db.Close
End Sub

insert module

Change the address to the location where your locked Access database is.

Step 5: Click on the Run Macro button, or press F5, to execute the application.

After a while, if it runs smoothly, your password protected Access database will open without asking password.

Related Articles