Microsoft KB Archive/296857

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

Article ID: 296857

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q296857



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 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.



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.



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.



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.

Additional query words: pra prb

Keywords: kbprb kbpending KB296857

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.