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.

ACC2000: Cannot Open Visual Basic Environment from Design View of a Database Object


View products that this article applies to.

Symptoms

When you try to open the Visual Basic Environment (VBE) from an object that contains a semicolon in its name, Access may stop responding and then shut down unexpectedly without error.

After restarting Access you may find that:
  • You can no longer open the object.
  • You cannot rename the object.
  • The database may be corrupted.

↑ Back to the top


Cause

There is a semicolon in the object's name, and the HasModule property of the object is set to Yes.

A semicolon is a reserved symbol for Microsoft Access. If you use a reserved symbol when you name an object, you may see unexpected behavior in the application.

↑ Back to the top


Resolution

If the database was converted from an earlier version of Access, remove the semicolon from the object name in the earlier version of Access before you convert the database.

If the object was created in Access 2000, re-create the object.

↑ Back to the top


More information

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. On the Insert menu, click Form. Click Design View, and then click OK.
  3. On the View menu, click Properties.
  4. On the Other tab in the property sheet for the form, change the HasModule property to Yes.
  5. Save the form as F;Form1, and then close the form.
  6. Close and then reopen the database.
  7. Open the F;Form1 form in Design view.
  8. On the View menu, click Code. Note that the Visual Basic Environment does not open as expected.
  9. Close the form.

    Note that Access may stop responding and then quit silently.

↑ Back to the top


Article Info
Article ID : 296857
Revision : 2
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 282