Microsoft KB Archive/828406

= The Shortcut That the Package Wizard Creates for a Password-Protected Database May Not Open the Database =

Article ID: 828406

Article Last Modified on 11/19/2003

-

APPLIES TO


 * Microsoft Office Access 2003
 * Microsoft Office Access 2003 Developer Extensions

-



This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you try to open a password-protected database by using the shortcut that is created during the Microsoft Office Access 2003 distribution package installation and the password for the database contains quotation marks (&quot;), you may receive the following error message:

The command line you used to start Microsoft Office Access contains an option that Microsoft Office Access doesn't recognize.

Exit and restart Microsoft Office Access using valid command-line options.



CAUSE
This problem occurs because the Package Wizard includes the password inside quotation marks in the command for the shortcut. For example, if the password for the database is pass&quot;word, the command for the shortcut that the Package Wizard creates is similar to the following command: &quot;C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE&quot; &quot;D:\Program Files\Northwind\Northwind.mdb&quot; /pwd &quot;pass&quot;word&quot;



WORKAROUND
To work around this problem, modify the command for the shortcut so that the password is not included inside quotation marks in the command.

For example, if the original command for the shortcut is the following command &quot;C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE&quot; &quot;D:\Program Files\Northwind\Northwind.mdb&quot; /pwd &quot;pass&quot;word&quot; modify the command to the following command: &quot;C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE&quot; &quot;D:\Program Files\Northwind\Northwind.mdb&quot; /pwd pass&quot;word



MORE INFORMATION
When you install the distribution package that the Package Wizard helps you to create, the setup creates a shortcut to start the application. By default, all the parameters of the command for the shortcut are included in quotation marks. If any of the parameters contain quotation marks, a mismatch in the starting quotation mark and the ending quotation mark occurs. As a result, Access 2003 does not recognize the parameters, and you receive the error that is mentioned in the &quot;Symptoms&quot; section of this article. However, after you click OK on the error message, Access 2003 displays the standard Logon dialog box for user authentication. If you type the valid user name and the valid password, the database opens successfully.

Additional query words: ACC2003

Keywords: kberrmsg kbpdwizard kbpackage kbprb kbwizard kbpackaging KB828406

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.