MS Access has stopped working

Hello

I built a database for a client which has been working fine until a massage appeared saying 'MS Access has stopped working' when the client went to add a new applicant.  This seemed to appear out of the blue as we have not made any changes to the coding behind this button.

I have resolved the problem by importing  an old form, but I want to try and understand why this has happened so it doesn't happen again. Does anyone have any ideas why this message appeared?

Thanks
LillyCAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Rey is most likely right - the form was corrupt, and restoring from a recent backup would fix that - but in many cases a single corrupt form is the canary in the coal mine, so to speak.

If you're not already doing so, you should implement a maintenance routine on the database, which includes:

1. Compact the database
2. Compile it - from the VBA Editor window click Debug - Compile. Fix any errors and continue doing that until the menuitem is disabled.
3. Compact again

You may also need to Decompile on occasion. To do that, create a shortcut with this as the Target:

"full path to msaccess.exe" "full path to your db" /decompile

Run that, then do the 3 steps above again.

It's also a good idea to occasionally move all objects to a new database container. Create a new database and import everything into it, then recreate any custom database properties, etc.

Also, be sure all machines are fully up to date in regard to Office and Windows.
0
 
Rey Obrero (Capricorn1)Commented:
a possible cause is a corrupted form.
the form you replaced was corrupted.
0
 
LillyCAuthor Commented:
Great advice, thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.