Access 2007 terminating with Memory Error

We are encountering an intermitent error upgrading a legacy Access 2003 application to Access 2016 for a client.  

Our office has done dozens of upgrades from 2003 to 2013 in recent years but this is the first one to 2016.  I don't know if the fact that this is going to 2016 is a factor, just thought I'd mention it.  When doing the upgrades we know what needs to be changed and all the 2003 to 2013 upgrades have gone smoothly.  Most of the functionality in this 2003 to 2016 is fine but one menu option is causing issues.  Issues I've never encountered before.

Sometimes the menu option will run fine but sometimes I get the following two messages when it executes.  Then the application shuts down.

Access Stopped Working
When I select the 'Check Online for a solution' I then get
Access not working 2
I have error handling in every procedure in the application but the error handling routines are not being invoked. When I get the Access has stopped working' message.

This error occurs on a client machine that is running Access 2007.

My first thought was to ask the IT support people to re-install Access but I wanted to see if the EE experts had any other ideas.

We have thoroughly tested this application in-house (and this menu option dozens of times) and never once had any issues or failures.  We use an exact copy of the clients data to do our testing.  

I realize I've not supplied specifics about the functionality of the menu option but I thought these messages might be indicative of a more general problem.
LVL 1
mlcktmguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Usually these kind of errors are unhandled by usual Error handling and they are more buggy interpretations from the Engine to your application.
The key to solve it is to replicate this issue...just find out when and how this error pops up...usually its "bad" design...(not necessary bad)...just desing that Access does not like it....it could be ActiveX related..objects not closing/getting released..something you have forgotten <-- for this last one decompilng is usually a way to spot it.
I haven't worked with Access 2007 a lot but my personal belief is that is more flacky than the newer versions...especially 2013 and rest are more robust without strange behavior.
Gustav BrockCIOCommented:
We have converted some old applications - from Access 97 -> Access 2000 -> Access 2016 - with zero glitches.

That won't help you, I know, but you mention that one menu option is causing issues.
So, how about deleting that option and then rebuild it?

Or, does the menu entry call some code not called otherwise? If so, you could have a corrupt code module (could also be code-behind-form).
Again, if so, delete the module and recreate it - by typing, no copy-paste.
Jim Dettman (EE MVE)President / OwnerCommented:
Look at the event logs and post the error here.

  and I'm with the others....I would rebuild the DB.  Assuming at this point that it complies fine (no errors).

Jim.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Does it only happen on a single machine? If so, then ensure that machine is fully up to date regarding Office and Windows.

If it occurs on all machines, then I would also suggest you create a new database and import everything.
mlcktmguyAuthor Commented:
Thanks for the suggestions.  I got an abandoned question notice but I'm working thru this,

GoIng to request 2016 be installed on the test machine and rebuild the entire front end DB.

I can't pinpoint the time of the error so currently can't check the error log.  If it occurs again I'll ask IT to check that out.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.