After installing Office 2010 SP1, you may receive random crashes when opening objects in certain databases and when trying to open the VBA window in those databases. If you look in the event viewer the crash info may look similar to the following:
Faulting application: msaccess.exe
faulting module: vbe7.dll
UPDATE: Microsoft is aware of the issue and has scheduled a fix to the VBE7.dll in the October 2011 Cumulative Update. You can workaround the issue by performing the following steps to decompile and recompile the database.
1. Make a copy / backup of your database.
2. On the problematic machine decompile the database by running the following from a Run command line: <path to database file> /decompile ex. C:\test.accdb /decompile
3. Close the database.
4. Open the database again normally.
In addition to this, if you experience the crash please send the error report when prompted to do so after the crash.
2625046 Access 2010 crashes in VBE7.DLL after installing Office 2010 SP1
Microsoft Online Community Support