For months Microsoft has know and have been working on a fix to a major issue that would immediately crash Access 2010 . There was a lively discussion started in July on Microsoft’s Answers site.
For months the band aid solution was to decompile the database in question.
- C:\dbwithissue.accdb /decompile
This worked just fine, but it was like playing Russian Roulette with your databases. You could go a day or so without any issue, but the crashes would return without notice.
It was determined the issue was a result of the VBE7.dll included with the SP1 update. Unfortunately, this dll was used by other Office applications. Which, I am speculating was the reason why it took so long to get the Hotfix published.
You can read up on the Access 2010 hotfix package (Vbe7-x-none.msp) and request the Hotfix by clicking here. Below is the warning that accompanies the Hotfix email.
WARNING This hotfix has not undergone full testing. Therefore, it is intended only for systems or computers that are experiencing the exact problem that is described in the one or more Microsoft Knowledge Base articles that are listed in “KB Article Numbers” field in the table at the end of this e-mail message. If you are not sure whether any special compatibility or installation issues are associated with this hotfix, we encourage you to wait for the next service pack release. The service pack will include a fully tested version of this fix. We understand that it can be difficult to determine whether any compatibility or installation issues are associated with a hotfix. If you want confirmation that this hotfix addresses your specific problem, or if you want to confirm whether any special compatibility or installation issues are associated with this hotfix, support professionals in Customer Support Services can help you with that.
Leave a Reply