Connecting To a Password Protected Access Database

Description

When attempting to connect to a password protected Access database I get a ODBC login error after entering a valid username and password.

Solution

When an Access database that uses a username other than "Admin" is saved, a *.mdw file is created in the same directory as the *.mdb file. If your ODBC driver is not connected to this file properly, you receive the above-mentioned error. Complete th followinng steps to properly configure your driver:
1. From the Windows control panel double-click on the ODBC icon to launch the ODBC Administrator.
2. From the list of Data Sources select the DSN for your Access database and click Configure....
3. From the driver configuration screen select the Database option from the System Database section.
4. Click on the System Database... button and browse to the folder containing your .mdw file. Select the *.mdw file and click *OK.
5. Exit the the ODBC Administrator to save the configuration changes.
You are now able to connect to your database without error.