Fix Microsoft Access Requesting a Password When Opening MDB Files
Question details
The user is experiencing an unexpected password prompt when trying to open MDB database files after migrating files or software to a new computer.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Opening legacy MDB files or running a commercial application that relies on an Access database on a new computer.
- Observed behavior
- Microsoft Access asks for a password to open the MDB file, even though no password was required or configured on the previous computer.
Before troubleshooting, determine whether the MDB file is a standalone database you created or a backend file used by a third-party commercial application.
Transfer the Associated MDW Workgroup File
Legacy Access databases often rely on user-level security stored in a separate MDW file. If this file is missing on the new computer, Access defaults to requesting a password.
Microsoft Access user-level security operates by tying MDB files to a specific Workgroup Information File (MDW). When migrating files to a new device, users frequently copy the MDB file but forget the MDW file, triggering an unexpected access denial.
Turn on your previous computer and navigate to the folder where your database or application was installed. Search for files ending in the .mdw extension.
Transfer the identified MDW file to a USB flash drive or a shared network folder to move it to your new computer.
On your new computer, paste the MDW file into the exact same folder path or directory as your MDB database file.
If you use a specific shortcut to launch the database, right-click the shortcut, select Properties, and ensure the Target path correctly references the newly copied MDW file.

Contact the Commercial Software Vendor
If the MDB file is part of a third-party software application, the vendor likely secured the database to prevent direct data tampering.
Check Microsoft Office Version Compatibility
Opening older MDB files with newer versions of Microsoft Access can sometimes cause compatibility issues or misread legacy security settings.
Looking for a Free, Highly Compatible Office Suite?
While Microsoft Access is required for managing specific MDB databases, WPS Office is an exceptional free alternative for handling your everyday documents, spreadsheets, and presentations. Enjoy a lightweight suite with excellent format compatibility and a seamless user experience.
- 1. Visit the Official Website: Navigate to the WPS Office website to download the latest free version for your operating system.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Files Easily: Launch WPS Office to instantly open, edit, and save your existing Microsoft Office documents without format changes.

Frequently Asked Questions
Why does Access ask for a password when I never set one?
This usually happens when you migrate files to a new computer but fail to copy the associated MDW Workgroup Information File. Without this file, Access falls back to a default security state and asks for a password.
Can I bypass the password on a commercial MDB file?
It is highly discouraged. Commercial vendors deliberately secure their backend MDB files to protect proprietary structures and prevent unauthorized edits that could break the application. You must contact the vendor for access or migration support.
How do I know if my database uses user-level security?
Check your original computer's installation folder. If there is an MDW file associated with your MDB file, or if the shortcut used to open the database contains a '/wrkgrp' command-line parameter, your database relies on user-level security.




