Article ID: 207891 - View products that this article applies to.
This article was previously published under Q207891
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
For a Microsoft Access 2002 version of this article, see 292302
When you try to start Microsoft Access by using the /pwd command-line option to open a database that is password-protected, the Logon dialog box is displayed, even if you supply the correct password.
The /pwd option is used to provide the user-level security account password, not the database password.
In order to use the /pwd command-line option to start Microsoft Access, implement User-Level Security.
Microsoft Access offers two ways to protect a database with a password:
The Security Account password is used when you define user-level security for a workgroup. With user-level security, you must type a username and a password to open a database. After the database is open, your username determines the type of access you have to each object in the database.
When you use the /pwd command-line option, it always applies to a Security Account password.
You may also see this behavior if you are using user-level security and you do not supply the correct user-level password. In this case as well, you do not receive an error message.
Important: Please make sure you are using the correct case as well. If, for instance, you have assigned the password "oneSock" to yourself, then you try using the the password "onesock" with the /pwd command-line option, Access prompts you for the password and you receive no error.
Steps to Reproduce the Behavior
For more information about the differences between security accountpasswords and a database password, click Microsoft Access Help on the Help menu, type Protecting a Microsoft Access database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about command-line options, click Microsoft Access Help on the Help menu, type Startup command-line options in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
(http://support.microsoft.com/kb/209207/EN-US/ )ACC2000: How to Use Command-Line Switches in Microsoft Access