This problem hit me today on my main working database after upgrading to Office 2010 SP1. To help out others I have post the text of a solution below as well as the link.
Access 2010 SP1 – You receive random crashes in certain database or when opening the VBA window in those databases after installing Office 2010 SP1
Applies To: Office | Office 2010 | Microsoft Office Access
Issue:
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:/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.
Best Regards,
Nathan Ost
Microsoft Online Community Support
see original at : http://answers.microsoft.com/en-us/office/forum/office_2010-access/access-2010-sp1-you-receive-random-crashes-in/d2bf6175-075a-4a12-a2b1-f55d40af271b
Leave a Reply