ACC2002: Access Quits Unexpectedly When You Try to Open the Visual Basic Environment from a Database Object (302784)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q302784
Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

When you try to open the Visual Basic Environment (VBE) from an object that has a semicolon in its name, Access may appear to stop responding and quit unexpectedly.

After you restart Access, you may find:
  • The object can no longer be opened.
  • The object cannot be renamed.
  • The database may be in a corrupted state.

CAUSE

You are trying to open the Visual Basic Environment from an object that was created in an earlier version of Access, that has a semicolon in its name, and that has its HasModule property set to Yes.

The semi-colon is a reserved symbol for Microsoft Access, and Access 2002 does not permit object names to contain reserved symbols. If you use a reserved symbol to name an object, you may see unexpected behavior in the application.

RESOLUTION

Remove the semicolon from the object name in the earlier version of Access before you convert or open the database in Access 2002.

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 Behavior

  1. Open the sample database Northwind.mdb in Access 2000.
  2. On the Insert menu, click Form.
  3. In the New Form dialog box, click Design View, and then click OK.
  4. On the View menu, click Properties.
  5. On the Other tab of the property sheet for the form, change the Has Module property to Yes.
  6. Save the form as F;Form1, and then close it.
  7. Close the database.
  8. Open the database in Access 2002.
  9. Open F;Form1 in Design view.
  10. On the View menu, click Code. Note that the Visual Basic Environment does not open as expected.
  11. Close the form.
Note that Access may then stop responding and quit unexpectedly.
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbbug kbpending KB302784
©2003 Microsoft Corporation. All rights reserved.