Access 2010 error "Microsoft Access has encountered a problem and needs to close.  We are sorry for the inconvenience."

Posted on 2011-10-28
Last Modified: 2012-05-12
I have been using Access 2010 since early this year to edit mdb files created in Access 2003.  This summer I started to encounter this error message sporadically "Microsoft Access has encountered a problem and needs to close.  We are sorry for the inconvenience."  Today it is happening when I attempt to open a module or view code behind a form.  Other times it has happened when I'm editing a form.  The only fix is to return to Access 2003, open the mdb file, repair the database, then open the db with Access 2010.  I cannot convert to an .accdb because my user community hasn't completely updated to Office 2010.  Please help.  Susan
Question by:scover22
    LVL 61

    Assisted Solution

    We had a similar situation migrating from Access 2003 to Access 2007.

    Between Front End corruption and differences between 2003 commandbars and 2007 ribbons, we eventually started maintaining two seperate versions of the Front End for both types of users, modifying the automatic install/update code to determine which version to put on the users' machines based on which version of office they were running.

    As an aside, 'mixed' versions of Access (specifically service packs) is cited as a known cause of corruption here:
    LVL 12

    Accepted Solution

    You might try to do a Decompile, and see if that works:

    Hope this helps,

    Author Comment

    Thank you for your suggestions.  I have to leave now, but will look into them later.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    In addition to the other posts...

    Make sure you run the Compact repair utility, and compile your code on a regular basis.
    LVL 84
    Many have reported good results from building a new .mdb file in 2010, and then importing everything into that file. Your 2003 users can still use it, of course, but it seems to cut down on corruption somewhat.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article will show you how to use shortcut menus in the Access run-time environment.
    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now