Database is in an unexpected state; MS Access Can't open it.

[Guest]

I have a mdb that when I try to open it, give the above error. The msg also
states that "If you have a copy of the DB in its originial format, use the
convert DB command... to convert it. If the original DB is no longer
available, create a new DB and import your tables and queries to preserve
your data."

I have tried to import the data, but it does not work. I can get to the data
in tables via excel (new DB query), but the queries with in the MDB file do
not import with all the parameters.

Can anyone help me fix this.

Also, it is not recognizing me as an authorized user, even though I am
supposed to be one of the admins.

 

[John Vinson]

I have a mdb that when I try to open it, give the above error. The msg also
states that "If you have a copy of the DB in its originial format, use the
convert DB command... to convert it. If the original DB is no longer
available, create a new DB and import your tables and queries to preserve
your data."

I have tried to import the data, but it does not work. I can get to the data
in tables via excel (new DB query), but the queries with in the MDB file do
not import with all the parameters.

Can anyone help me fix this.

Also, it is not recognizing me as an authorized user, even though I am
supposed to be one of the admins.

The database is almost certainly corrupt. See

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

for some suggestions.

John W. Vinson[MVP]