Originally Posted by Tubbritt
Are you 100% sure you don't have your database set to create a backup of itself when opened ?
If you do, and it crashed, there will be perfectly working copy of it in the same path where you where running the database from. It will have a ~1 on the end of it or some other number depending on how many times it crashed.
Beyond that, I cannot think of anything other than going to the server backup. Surly there's one there.
I used to have this type of problem earlier. When I analysed it has happened when you store more number of attachments in the database records.Also when synchronize two database by forms and queries particularly the relational one. If the database you are importing is clean and simple you do not get issues.
Eventhough the error comes keep pressing the enter button sometimes it opens with some limitations but that is enough to repair the database or bring your valuable records.
Also when you design a database follow a correct convention in naming forms and vaiables.
Be sure atleast once in a week optimize the database.