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
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

203 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2011-11-09T15:02:01+00:00

    Hi Johnomahoney,

    If you look in the event viewer, what does the error signature for the crash look like?

    Best Regards,

    Nathan O.

    Microsoft Online Community Support

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-11-09T14:50:39+00:00

    Just to be clear, the hotfix that was released was intended to fix the specific crashing issue in KB 2625046.

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

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

    After installing this fix, there is a chance Access could still crash due to other reasons or you could still receive other error messages.  Unfortunately, it won’t fix all crashes and all error messages.  With that being said, if you are still running into crashes or additional error messages after installing this fix, then at this point, I would recommend opening up a ticket with Microsoft so that we can look into the issue with you or if you are able to consistently reproduce the problem, you may want to start a new thread with the exact symptoms and repro steps.

    Online Assisted Support Options (create cases online) - http://support.microsoft.com/select/default.aspx?target=assistance

    Best Regards,

    Nathan O.

    Microsoft Online Community Support

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-11-09T14:26:04+00:00

    I have downloaded the hotfix but if I try to open VB, -  Access still crashes

    Is there something else I need to do??

    Thanks

    John

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-11-09T09:23:41+00:00

    Saar,

    Following your post a few moments ago I opened a database which I had been working on yesterday without any problems. It had been modifying and operating normally after installing the fix.

    This morning, when I attempted to use a button within the main opening page to open a form that I had been working on yesterday, I got ....................... Yes, you were right. I got a Return without Gosub error.

    The only thing which has changed since yesterday is that yesterday evening after finishing work on that database I went to Microsoft Update and downloaded and installed the current batch of monthly Microsoft Updates. These included a group of Office 2010 updates.

    Aaagh ........... it looks as though the team working on the fix had perhaps not integrated their work with that of the team working on the other Office 2010 updates.

    So you are right ........... something is STILL not fixed.  This is getting beyond reasonable. Nathan, please get onto this urgently.

    ADDENDUM in case it helps: Having done some further work to narrow down the point where the Return without Gosub error was occurring, the button concerned used an embedded macro to open the required form. When I replaced this embedded macro with a standard VB instruction to open the form, the error did not occur. I'll keep testing.

    Was this answer helpful?

    0 comments