I tried to open a db this morning, I am getting an error message:
The database is in an unexpected state; access cant open it.
The db has been converted from a prior verion off access by using the DAO CompactDatabase method instead of the Convert database command.
your database objects cant be recoverd.
How, why does this happen? There had been no issues with this db in access 2003 for 3 months and all of a sudden it gets toasted. Is there anything i can do , i tried importing to a new db and still get the same message.