Unexpected State - converted from prior version

[KellyK]

I know I am not the first to post this problem but I have tried every possible recovery method I know of, and I'm hoping for a new suggestion.

When attempting to open a database, I get the error "the database is in an unexpected state... converted from a prior version of Access using DAO compact database.."

I have tried importing the tables into a new database. No dice, cannot open the corrupted database file to access the tables.

I tried using Jetcomp.exe. It's able to compact the database but I still cannot get in.

Next came decompiling at the command line.. I receive an error that I don't have permissions to access the object, yet it is not password protected and I've always had permissions to open it.

Then I tried following faq181-1005.. importing the tables into Excel. When I get to the screen that displays the tables, the only table listed is MSysCompactError. I imported it anyway, and every entry in the table says "You do not have the necessary permissions to use the 'tablename' object. Have your system administrator or the person who created this object establish the appropriate permissions for you." where 'tablename' is an individual table in the database. There is a line for every single table in the database.

I'm all tapped out.. does anyone have a magic fix for me? Kelly

 

[thornmastr]

Kelly,

I gather from the message you are receiving from Msyscompacterror that you are dealing with a secured database.

If so, are you sure that
1) you are connected to the correct workgroup, and
2) you have the permissions you think you have?
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[KellyK]

Again, there is no security on this database. All you need is access to the drive (which I have) and it will open for you. No password, no security, nothing. Kelly

 

[DRich12]

Do you have a copy of the db before the change? If so can you open it now? If you can open the old db try to open it in the new version and let access do the conversion for you. Working from a copy of course.