Corrupted Acces Database

[Soulspike]

Hello,

I am running access 97 and my database appears to be corrupt. When I open it I get the following error: "The Database Turnover.mdb needs to be repaired or isn't a database file."

I choose to repair it and it says that it was successful. Then when it trys to open the database I get the dreaded "Micorsoft Access has encountered a problem and needs to close. Wa are sorry for the inconvenience." I am at a loss as to what I can do to recover my data.

Any suggestions would be greatly appretiated.

Thanks

[DonRayner]

Try creating a new database and then importing all your tables/queries/forms/reports and modules. If it is still giving you problems then start by importing one thing at a time untill you find what is causing the problem with the DB.

Doing this has saved my a$$ numerious times :)

[Soulspike]

Thank you so much, it worked flawlessly. I was able to get all my tables back and restore them in to a back-up file I had. Thank you so much for the help, you are a life saver.

[DonRayner]

Glad I could help....