Microsoft KB Archive/248970: Difference between revisions
m (Text replacement - "<" to "<") |
m (Text replacement - ">" to ">") |
||
Line 108: | Line 108: | ||
# If the Project window is not visible, click '''Project Window''' on the '''View''' menu. | # If the Project window is not visible, click '''Project Window''' on the '''View''' menu. | ||
# In the Project window, click '''Class Modules'''. A list of the class modules appears. | # In the Project window, click '''Class Modules'''. A list of the class modules appears. | ||
# Right-click the problem module, and then click '''Remove <module name | # Right-click the problem module, and then click '''Remove <module name>'''. | ||
# You are asked to export before removing the module. Click '''Yes'''. | # You are asked to export before removing the module. Click '''Yes'''. | ||
# In the '''Export File''' dialog box, click the '''Save in''' box, and then click '''Desktop'''. Click '''Save'''. | # In the '''Export File''' dialog box, click the '''Save in''' box, and then click '''Desktop'''. Click '''Save'''. | ||
# On the '''File''' menu of the Visual Basic Editor, click '''Import File''' | # On the '''File''' menu of the Visual Basic Editor, click '''Import File''' | ||
# In the '''Import File''' dialog box, click the file that you just exported, and then click '''Open'''. | # In the '''Import File''' dialog box, click the file that you just exported, and then click '''Open'''. | ||
# On the '''File''' menu, click '''Save <database name | # On the '''File''' menu, click '''Save <database name>'''. | ||
# On the '''File''' menu, click '''Close and Return to Microsoft Access'''. | # On the '''File''' menu, click '''Close and Return to Microsoft Access'''. | ||
# Try opening the module in Design view. The module should open without error. | # Try opening the module in Design view. The module should open without error. |
Latest revision as of 08:43, 21 July 2020
Article ID: 248970
Article Last Modified on 11/25/2002
APPLIES TO
- Microsoft Access 2000 Standard Edition
This article was previously published under Q248970
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
SYMPTOMS
When you try to open a Visual Basic for Applications class module in Design view, you see one or more of the following behaviors:
- Access stops responding (hangs).
- Visual Basic for Applications opens, but the Project window is not visible even after you click Project Window on the View menu.
- Visual Basic for Applications opens but then hangs after a few seconds.
- You see the following error message:
When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
NOTE: The actual memory address may vary.
CAUSE
This problem can occur under the following circumstances:
- There is a class that declares an event.
- A change is made to a module/class that this class calls.
- The project is recompiled and saved.
- The project is compacted.
RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).
To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
If your database is already affected, you can clear up the corruption by exporting and then importing the problem module as detailed in the following steps:
- Open the database.
- In the Database window, click Modules, and then click New. The Visual Basic Editor starts.
- If the Project window is not visible, click Project Window on the View menu.
- In the Project window, click Class Modules. A list of the class modules appears.
- Right-click the problem module, and then click Remove <module name>.
- You are asked to export before removing the module. Click Yes.
- In the Export File dialog box, click the Save in box, and then click Desktop. Click Save.
- On the File menu of the Visual Basic Editor, click Import File
- In the Import File dialog box, click the file that you just exported, and then click Open.
- On the File menu, click Save <database name>.
- On the File menu, click Close and Return to Microsoft Access.
- Try opening the module in Design view. The module should open without error.
STATUS
Microsoft has confirmed that this is a problem in Access. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.
Additional query words: pra
Keywords: kberrmsg kbbug kbpending KB248970