MS Access has stopped working


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?

LillyCDatabase DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Rey Obrero (Capricorn1)Commented:
a possible cause is a corrupted form.
the form you replaced was corrupted.
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LillyCDatabase DeveloperAuthor Commented:
Great advice, thank you very much.
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 Access

From novice to tech pro — start learning today.