ACC2000: Error When You Try to Use a Shortcut to Open a Password-Protected Project (210619)

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

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

SYMPTOMS

If you create a shortcut in Microsoft Windows that points to a password-protected Visual Basic Editor project, you may receive the follow incorrect error message when you double-click the shortcut:

Microsoft Access can't find the procedure '.'

Instead, the error should indicate that a Visual Basic Editor password is needed before you can open the module. However, you cannot pass a Visual Basic Editor password through the shortcut.

RESOLUTION

Use Access to open the database. When the database is open, press ALT+F11 to open the Visual Basic Editor. You then receive a prompt for the Visual Basic Editor password.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Problem

Create a new database.
Create a new module, and then save it.
On the Tools menu, click DatabaseName Properties, click the Protection tab, click to select the Lock Project for Viewing check box, type (and confirm) a password, and then click OK.
Close the Visual Basic Editor. In the Access database window, drag the module to the desktop to create a shortcut to the module.
Quit Microsoft Access.
Double-click the shortcut. Note that Access displays the incorrect error message described in the "Symptoms" section of this article.