the Database is in an unexpected state

G

Greg Lemke

I recently upgraded from Access 200 to Access 2002 and
had been opening a MDB file that had been created under
Access 97 and converted so that I was able to use it in
2000. I tried to open the file today and get the error
message... "the database is in an unexpected
state;Microsoft Access can't open it" the error owindow
offers a suggestion that the database was not properly
converted (conversion happened 3-4 years ago) and if I
have the original database I should re-convert it. It
also suggests that I might import the data from this
database into a new one. Import doesn't work (same error
pops up and reconverting a 4 year old original is out
because I have a 6 month old copy of the bas database I
could fall back on if I can fix this one. Any suggestions
out there?
 
J

Jeff Boyce

Greg

It might be possible to open a new, empty .mdb and attempt to import all the
objects from the munged one. If you do this one-at-a-time (all tables,
first, then all queries, ...), you may discover that a single object (a
particular table, or form, or code module) is broken. You could import
everything except that one, then reconstruct, as another alternative.

Now, how did your database get in that state? If a PC with an open
front-end connected to a networked back-end gets shut down (say, a power
outage), both the front- and back-ends could suffer corruption.

Good luck!

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top