Microsoft KB Archive/302784

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

Article ID: 302784

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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.

Additional query words: pra

Keywords: kbbug kbpending KB302784

-

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

© Microsoft Corporation. All rights reserved.