MS Access Crashed an now all Form objects and code modules are missing
Posted
by
owlie
on Stack Overflow
See other posts from Stack Overflow
or by owlie
Published on 2011-01-11T06:04:43Z
Indexed on
2011/01/15
21:53 UTC
Read the original article
Hit count: 150
I was adding a form to our Access 07 db. I copied an existing form to use as a template, renamed it, and saved it. I opened a different form to check something and Access crashed. When I reopened the database it says: "Access has detected that this database is in an inconsistent state, and will attempt to recover the database." etc.
When it reopened - all forms and reports were missing. Saved queries remain. The error message states that object recovery failures will be noted in a Recovery Errors table - but this table wasn't created. The links to the be database remained intact.
The database is split - I was experimenting with a form on a front-end copy which might have something to do with it.
Any ideas what would cause this (I can see loosing recent work - but nixing all form objects?!) And is there any chance of recovery?
© Stack Overflow or respective owner