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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-08-03T21:33:58+00:00

    Just came across this thread along with a MS KB article that seems related. See:

    Been suffering Access 2010 crashes while attempting to build .MDE's from .MDB (v2002-2003). Have tried importing to a clean/fresh .MDB to limited success.

    I'd been working on the assumption that my dev environment was the cause because I've been trying to run Office 2003/2007/2010 side-by-side; discovered that Access and Word want to do a "mini-re-install?" whenever switching different version. Came across a KB article discussing problems in this environment as being related to running as a non-admin when this switch occurred (running as admin on the swap is suppose to alleviate the issue). Sorry can not recall the specific KB # at this time. NOTE: The swap under a non-admin account would change enough of the environment to run the the different version, but key elements were locked in under the previous version).

    As well didn't really resolve the issue I was seeing vis-a-vis VBE7/VBA problems (running .MDE under Access 2010 runtime complained about corrupt VBE7.dll's).

    My short term solution so far has been to build the .MDE under Access 2003, hopefully having avoided slipping an 2007 or 2010 feature.

    H. Mertens

    Contract & Consulting Services

    Vancouver BC

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-08-02T09:15:29+00:00

    Just a piece of (much-needed) good news from Steven Thomas (a member of the Microsoft team working on this issue). I hope that he will not mind us quoting it in this context:

    'Folks, we've got some 32-bit repros for this now and are working on a fix. I'll write a new post about it, but I wanted to make sure to acknowledge your help here in this thread.

    Thank you so much for all the information you've given - it has been immensely helpful.

    -Steven

    1 Aug 2011'

    So hopefully not long to wait now.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-07-29T15:07:45+00:00

    That is very good info, even if it is a single sample.  I hope the MS folks working this problem see that and think about the ramifications.  E.g. is it possible that the problem is just a glitch in SP1's install script?  If so, it might explain part of the testing failure.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-07-29T13:09:53+00:00

    Here's the latest...

    My app crashed on opening again yesterday. "On opening" isn't actually accurate...it opens with my login form and then crashes as soon as it tries executing code. So I decompiled, but this time it still wouldn't open. I hadn't uninstalled SP1 yet so I was ready to rip that out. I went into Contol Panel/Programs/Microsoft Office 2010 ProPlus and saw the Repair option and gave that a try first. Hmmm, my app opened fine after that. I made some code changes yesterday (in design view, mind you) and shut down. It reopened successfully.

    One observation is not a scientific study, but maybe running a repair on Office 2010 is the solution. I'll keep you posted.

    DB

    Was this answer helpful?

    0 comments