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 ("), you may receive the following error message:
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"
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
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.
Additional query words: ACC2003
Keywords: kberrmsg kbpdwizard kbpackage kbprb kbwizard kbpackaging KB828406