Unlock Access Database Password: Step-by-Step

If you’ve inherited a Microsoft Access database that’s password-protected and you need to get in, this guide walks you through the legitimate ways to unlock it. You’ll learn how to remove a database password when you know it, and what to do if you’ve forgotten it—without resorting to risky third-party cracking tools. Before you start, make sure you have access to a Windows PC with Microsoft Access installed (2016, 2019, or Microsoft 365 versions work).

What You’ll Need

A Windows computer with Microsoft Access installed.
The password-protected .accdb or .mdb file.
The database password (if you know it) or permission from the owner to reset it.
Administrator rights on the PC to create or modify files in the Access installation folder (if applicable).

Step-by-Step

Open Access without opening the database. Launch Microsoft Access from the Start menu. If Access opens a recent file list, close that window. You should see the main Access start screen with templates.
Go to the File menu. Click the File tab in the top-left corner, then select Open from the left-hand menu.
Browse to the database file. Click Browse and navigate to the location of your .accdb or .mdb file. Select the file, but do not double-click it yet.
Open exclusively. Click the small down arrow next to the Open button in the file dialog. From the drop-down menu, select Open Exclusive. This is critical—it ensures you have exclusive access to the file, which is required to change or remove a password.
Enter the password if prompted. If you know the password, type it in the dialog box and click OK. If you don’t know it, skip to the Troubleshooting section below.
Open the Set Database Password dialog. Once the database is open, go to the File tab again, then click Info. In the Info pane, you’ll see a button labeled Encrypt with Password. Click it.
Remove the password. In the Set Database Password dialog, you’ll see a field for the current password. Leave the New Password and Verify fields blank, then click OK. Access will remove the password and save the change.
Test the database. Close the database and reopen it normally. It should open without prompting for a password.

Common Mistakes

Not opening exclusively. If you open the database in normal mode, the Encrypt with Password option may be greyed out or you’ll get an error. Always use Open Exclusive.
Typing a new password when you meant to remove it. The Set Database Password dialog is the same one used to set a password. If you type anything in the New Password fields, you’ll set a new password instead of removing it. Leave them blank.
Using the wrong file format. Password removal works on .accdb (Access 2007 and later) and .mdb (Access 2003 and earlier) files, but the steps may differ slightly for older .mdb files. The steps above work for .accdb; for .mdb, you might need to use the Tools > Security > Unset Database Password menu in older Access versions.
Forgetting to back up the database. Before making any changes, always copy the file. If something goes wrong, you can restore the original.

Tips

Use a strong password when setting one. If you’re re-protecting the database, use a mix of letters, numbers, and symbols. Write it down in a secure place—Access does not offer a password recovery feature.
Keep a backup copy. Store a backup of the password-protected database in a safe location. This way, you can always revert if you accidentally remove the password and need it back.
Consider database-level security. For multi-user scenarios, a database password is the simplest protection. For stronger security, use user-level security (in .mdb) or encrypt the database with a certificate (in .accdb).
Check for linked tables. If your database links to other databases, those may have their own passwords. You’ll need to update the linked table connections after removing the password.

Troubleshooting

You forgot the password. There is no official way to recover a lost Access database password. If you have the file and no password, you have a few options: try common passwords you might have used, ask the person who set it, or use a third-party recovery tool (use at your own risk—these tools are not guaranteed to work and may damage the file). The most reliable method is to restore from a backup that isn’t password-protected.
The Encrypt with Password button is greyed out. This usually means the database is not open exclusively. Close the database and reopen it using Open Exclusive from the Open dialog.
You get an error when trying to open exclusively. This often happens if the database is already in use by another user or process. Make sure no one else has it open, and check that the file isn’t read-only. Right-click the file in File Explorer, select Properties, and uncheck Read-only if it’s checked.
The password removal seems to work but the database still asks for a password. This can happen if the database has multiple layers of protection, such as a VBA project password or a user-level security file. You’ll need to remove those separately. For VBA passwords, open the VBA editor (Alt+F11), go to Tools > Properties, and clear the password there.
You don’t have Access installed. If you only have the Access Runtime, you cannot change passwords. You’ll need a full version of Access or ask someone who has it to help.

Frequently Asked Questions

Can I unlock an Access database without knowing the password?

Not officially. Microsoft does not provide a password recovery feature. You can try third-party tools, but they are not reliable and may corrupt the database. The safest route is to restore from a backup or contact the person who set the password.

Does removing the password affect the data?

No, removing the password only changes the file’s encryption settings. All tables, queries, forms, and data remain intact.

Can I remove the password from an .mdb file using the same steps?

The steps are similar, but the menu location differs. In Access 2003 and earlier, go to Tools > Security > Unset Database Password. In newer versions, the steps above work for .mdb files, but you must open exclusively.

What if the database is shared on a network?

You need exclusive access to the file. Make sure no other users have it open, and that you have write permissions to the network folder. It’s often easier to copy the file to your local drive, remove the password, and then copy it back.

Will removing the password make the database less secure?

Yes, anyone with access to the file can open it. If you need to protect sensitive data, consider using a different security method, such as encrypting the file with a certificate or using user-level security.

Can I set a new password after removing the old one?

Yes, simply open the database exclusively, go to File > Info > Encrypt with Password, and enter a new password in the New Password and Verify fields.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →