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

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
scover22Asked:
Who is Participating?
 
danishaniConnect With a Mentor Commented:
You might try to do a Decompile, and see if that works:
http://www.fmsinc.com/microsoftaccess/performance/decompile.asp

Hope this helps,
Daniel
0
 
mbizupConnect With a Mentor Commented:
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:
http://allenbrowne.com/ser-25.html
0
 
scover22Author Commented:
Thank you for your suggestions.  I have to leave now, but will look into them later.
0
 
Jeffrey CoachmanMIS LiasonCommented:
In addition to the other posts...

Make sure you run the Compact repair utility, and compile your code on a regular basis.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
All Courses

From novice to tech pro — start learning today.