Access 2010 SP1 – You receive random crashes in certain database or when opening the VBA window in those databases after installing Office 2010 SP1

Hi Mike,

Sorry for not responding sooner.  I personally haven’t had a chance to apply the hotfix against a runtime build, but I would assume it should apply to that as well since they normally apply to both the full and run-time versions of Access. 

Unfortunately, I don’t have any information as far as a timeline for if or when SP2 will be released.  So my recommendation would probably be to ensure your users install this cumulative fix after your application is installed.  You may be able to chain this to the installation of your application.  You would just want to ensure, you install the proper bit version of the fix to match the Access 2010 bit version you installed.

Best Regards,

Nathan O.

Microsoft Online Community Support

I installed the Hotfix on Monday morning and have been working on the same database all week now without any issues.  This is the same database that was crashing previously.

So far in my case the Hotfix appears to be working.

Nathan,

Thank you for keeping us updated and you deserve some credit for being a middle man in this mess.  I hope the team behind you takes the time to read through these 15 pages, after that I'd expect them to buy you lunch and bring you coffee for a week.

Nathan,

1. Go to the Hotfix KB page: http://support.microsoft.com/kb/2596585
2. Click on "View and request hotfix downloads" in the upper left-hand corner.
3. In the list of hotfixes, you see the following table:

Select | Product | Language | Platform | Release | Fix name

[ ] | Microsoft Access 2010 | All (Global) | x64 | sp2 | office2010kb2596585fullfilex64glb

==> In the "Release" column, "sp2" is shown. I guess this is what Jon is referring to.

Best regards,

    Heinzi

Nathan,

You asked re Release SP2 location. This is on the download page at the URL shown below (see 'Release' column on copy below). It is also noted that the SP2 fix is only intended to apply to SP1 systems (see copied advisory sections below).  As you will understand, after this extended saga we have lost a certain amount of trust in Microsoft's team, and we request that you specifically check with the Fix team and confirm that we should install the SP2 fixwithout first installing SP1 again.

Regards

Jon

Issue that this hotfix package fixes

Assume that you open a database that contains Visual Basic for Application (VBA) code. In this situation, Microsoft Access 2010 may crash when you change the database.

Note This issue occurs after you apply Microsoft Office 2010 Service Pack 1 (SP1).

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

Important

• A hotfix is intended to correct a specific problem.
• Apply the hotfix only to systems that are experiencing the specific problem.
• Installing the incorrect hotfix can cause damage to your system.
• If you are not sure whether the hotfix is the correct one for your system, do not install it.
• Hotfixes are included in subsequent service packs that are safer to install through Microsoft Update

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2596585&kbln=en-us