By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 996 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Aug 29 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Aug 29, 6:32*am, Gwindor <gwin...@verizon.netwrote:
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
Aug 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.