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

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

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.

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

Jon,

I am not seeing where it says, “release SP2”?  If possible, could you guide me to where you see this listed?  This fix is not considered SP2, but is a cumulative update.  Normally cumulative updates are then a part of the next service pack whenever it is released.  Which would mean if a user hasn’t installed the cumulative update, they most likely would receive it when the next service pack is released and installed.

As mentioned in the “Prerequisites” section of the article, it states you have to have Microsoft Office 2010 installed (if it depends upon another service pack or update it would list it here).  The fix doesn’t depend upon having SP1 installed or any other fixes installed.  Also as mentioned in the “Hotfix Replacement Information”, it states this hotfix doesn’t replace a previously released hotfix.

So to summarize, this fix is not SP2 nor does it replace SP1.  I would normally recommend installing updates in the order they were released, which would mean installing SP1 and then the cumulative fix.  But since this fix doesn’t depend upon SP1 being installed, you can install it without having SP1 installed and when you do install SP1; it shouldn’t replace the newer version of the files listed in this article.

As mentioned by others, when downloading the fix, you will want to make sure you download the hotfix that matches the bit version of Office you have installed.  I believe the hotfix site currently looks at the OS bit (64 or 32) and by default shows the hotfix for that build.  If you have 32 bit Office / Access 2010 installed on a 64 bit OS, you will want to make sure you download the 32 bit (x86) hotfix.

Best Regards,

Nathan O.

Microsoft Online Community Support