MS Access Crashed an now all Form objects and code modules are missing
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开发者_如何学C 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?
This sounds bad. Do you have any back-ups, prior versions or shadow copies? Check the properties of the .MDB through windows Explorer to see if you might have other versions. Check your system restore to see when the last snap shot was made. I don't think you will be able to recover from this, but you can probably minimize the damage, and hope for a best case scenario of only losing your most recent changes.
精彩评论