Access 2010 Crashes

You receive random crashes in certain data

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.

Workaround: 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: /decompile ex. C:\test.accdb /decompile

3. Close the database.

4. Open the database again normally.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s