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

Anonymous
2011-07-20T15:29:21+00:00

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:

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:  <path to database file> /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.

2625046 Access 2010 crashes in VBE7.DLL after installing Office 2010 SP1

http://support.microsoft.com/default.aspx?scid=kb;EN-US;2625046

Best Regards,

Nathan Ost

Microsoft Online Community Support

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2011-10-29T04:36:47+00:00

Hey Everyone,

It looks like the hotfix for this issue has been released and can be downloaded from the link below:

Description of the Access 2010 hotfix package (Vbe7-x-none.msp): October 25, 2011 - http://support.microsoft.com/kb/2596585

In addition to this, KB 2625046 which describes this issue will also be updated to point to the fix above.

Best Regards,

Nathan Ost

Microsoft Online Community Support

Was this answer helpful?

4 people found this answer helpful.
0 comments No comments

203 additional answers

Sort by: Newest
  1. Anonymous
    2011-10-17T03:00:59+00:00

    One more thing @ Nathan. if you've fixed the Sp1 issue then for gods sake tell us where to download it from so we can install it on our customers machines and know it's done instead of hoping they have updates turned on. Why be so evasive about it?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2011-10-17T02:53:51+00:00

    After a decade of developing in Access and more recently months of head scratching and wondering what on earth the Access Team are playing at I've decided to give-up and switch to another platform before I start losing customers and it's to late. 

    If Ms carries on like this then Access RIP, there's a lot of other players out there just itching for this sort of opportunity. Ms needs to start pulling it's finger out of its ears and start listening to its captive followers.

    Bye

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2011-10-15T21:44:53+00:00

    Amen, brother!

    Has anyone looked at LightSwitch?  I have not, but some are calling Access.Net.

    I'd love to hear anyone's input on LS.

    Bruce

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2011-10-15T21:42:26+00:00

    Access has been my bread and butter from time to time over the years. And I have a lot to be thankful for. Many was the time that people told me something is impossible on Access. And time and again I was able to prove them wrong.

    I am sad to say that I agree with Mike. I told my husband just yesterday that if something does not happen very soon with a long lasting effect that I will have no choice but to move to a different platform.

    I have read in technical magazines that Access is no longer a priority for MS and did not want to believe it. This situation is obviously clear proof.

    What disappoints me is that my customers are mainly people with smaller businesses who cannot afford expensive licenses. Microsoft Access has always fit this niche of the market perfectly.

    S

    Was this answer helpful?

    0 comments No comments