We help IT Professionals succeed at work.

MS Access has stopped working

LillyC
LillyC asked
on
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
Comment
Watch Question

Top Expert 2016
Commented:
a possible cause is a corrupted form.
the form you replaced was corrupted.
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
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.
LillyCDatabase Developer

Author

Commented:
Great advice, thank you very much.