After you install Microsoft Office 2010 Service Pack 1 (SP1), you may experience random crashes when you work with Microsoft Access 2010 databases. These crashes may occur in those databases when you open objects, or you try to use the Visual Basic Editor. When you look in Event Viewer, the error signature resembles the following:
Faulting application: msaccess.exe
Faulting module: vbe7.dll
To resolve this issue, install update 2553385. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Description of the Office 2010 update: December 13, 2011
This issue was originally fixed in the following October 2011 hotfix package:
Description of the Office 2010 hotfix package (Vbe7-x-none.msp): October 25, 2011
To work around this problem, decompile and then recompile the database. To do this, follow these steps:
- Make a copy or backup of your database.
- On the computer that is exhibiting the problem, decompile the database. To do this, at a command prompt, run the following command where c:\folder\test.accdb is the path of your database together with the database file name:
- Close the database.
- Open the database in Access 2010 SP1.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.