The Shortcut That the Package Wizard Creates for a Password-Protected Database May Not Open the Database (828406)
The information in this article 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.
SYMPTOMSWhen 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. CAUSEThis 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" WORKAROUNDTo 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 MORE INFORMATIONWhen 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.
Modification Type: | Minor | Last Reviewed: | 11/19/2003 |
---|
Keywords: | kbwizard kbPDWizard kbPackage kbPackaging kberrmsg kbprb KB828406 kbAudDeveloper |
---|
|