can't import tables from table in "unexpected state"

[Gwindor]

I have a client who that was using an mdb file, and they appear to
have accidentally attempted to compact/repair or convert it, and then
tried to stop this activity in mid-process. Oy vey.

If I attempt to open the file, I get an error message saying the
database is in an "unexpected state". I tried importing the tables
into a new file, but the import tool in access says gives the same
message.

I tried a couple tricks to see if there was a way of getting at the
tables. But nothing has worked so far.

It seems unlikely to me that the data is completely inaccessible. Does
anyone know a way to get at the data in this .mdb file? Is recovery
possible?

Thanks.

[Bruce]

On Aug 29, 6:32*am, Gwindor <[e-mail]:

I have a client who that was using an mdb file, and they appear to
have accidentally attempted to compact/repair or convert it, and then
tried to stop this activity in mid-process. *Oy vey.

If I attempt to open the file, I get an error message saying the
database is in an "unexpected state". *I tried importing the tables
into a new file, but the import tool in access says gives the same
message.

I tried a couple tricks to see if there was a way of getting at the
tables. *But nothing has worked so far.

It seems unlikely to me that the data is completely inaccessible. Does
anyone know a way to get at the data in this .mdb file? *Is recovery
possible?

Thanks. * * * * * * * *

The first thing to do is to make a copy of the original database and
leave the original alone. Once that is done...there is a wealth of
information here on recovery:

http://www.granite.ab.ca/access/corruptmdbs.htm

Good luck!

Bruce