Database won't open, Placed in a state.

[FFDiz]

I am getting the following Error:

"This database is in an unexpected state; Microsoft access cannot open it.

"This database has been converted from a prior version of Microsoft access by using the DAO CompactDatabase method instead of the Convert Database command on the tools menu. This has left the database in a partially converted state.

"If you have a copy of the database in its original format, use the convert database command on the tools menu to convert it. If the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered."

The database is on the server. Nothing was changed. Someone in our IT department says they simply opened it and then closed it. I think that they had their access program set to compact and repair on close.

I have tried to import the tables but am gettting the same errors.

I have the original database but it is an old backup that is missing data.

Can someone HELP

 

[Kelemit]

Do exactly what it says.

Open the backup database, delete all the tables in there (or maybe play it safe and rename them all as back up). Then import ALL the tables from the now corrupted database.

If you have made any changes to forms / reports they will be lost. Hopefully your backup database has all the LATEST forms and reports created.

This way you save your data and you will have all the old forms from the backup database.

Suffice it to say, I would recommend using a COPY of the backup before you do this.

Kelemit