We are experencing the same problem as described here in a post on Microsoft Answers. However was are also still occasionally seeing the problem after uninstalling SP1.
Has anyone come across any better workarounds?
Microsoft: can we please have some information on when this is likey to be fixed - this is a major problem!
--------------------------------------
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
Version: 14.0.6024.1000
Stamp: 4d83e4fc
faulting module: vbe7.dll
version: 7.0.16.19
stamp: 4d430aec
Workaround:
Microsoft is aware of the issue and it is currently being investigated. In order to work around the problem, you can try the following:
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: MSACCESS.EXE <path to database file> /decompile
(example: C:\Program Files (x86)\Microsoft Office\Office14\MSAccess.exe "C:\folder\database.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.
--------------------------------------