Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.




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

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

↑ Back to the top


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 ("), 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.

↑ Back to the top


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"word, the command for the shortcut that the Package Wizard creates is similar to the following command:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\Program Files\Northwind\Northwind.mdb" /pwd "pass"word"

↑ Back to the top


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
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\Program Files\Northwind\Northwind.mdb" /pwd "pass"word"
modify the command to the following command:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\Program Files\Northwind\Northwind.mdb" /pwd pass"word

↑ Back to the top


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 "Symptoms" 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.

↑ Back to the top


Keywords: KB828406, kbprb, kberrmsg, kbpackaging, kbpackage, kbpdwizard, kbwizard

↑ Back to the top

Article Info
Article ID : 828406
Revision : 4
Created on : 11/19/2003
Published on : 11/19/2003
Exists online : False
Views : 265