Database is in an Inconsistent State

[Leec]

I have an Access 2007 database that was working just fine until the
computer's power plug came loose while I was using the database. Now, when I
try to open the database, I get the 'MS Access has detected that the database
is in an inconsistent state' message. Then if I click 'OK' to repair it, I
get a 'This is not an MS Access database' message. I am not using a front-end
or back-end server. This is a very simple database on my home computer. I
cannot use the Access 'compress and repair' facility because the db has to be
open to use it. How can I get my database back in working order!

 

[Gina Whipp]

Leec,

Ummm, skip down to the second link and see if you can recover your data!

Sounds like corruption...
http://www.granite.ab.ca/access/corruption/symptoms.htm. I would make a
back-up, make another back-up and then first try importing everything into a
new database. Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm. And after all
of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances
apply to you.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[CompGeek78]

I have an Access 2007 database that was working just fine until the
computer's power plug came loose while I was using the database. Now, when I
try to open the database, I get the 'MS Access has detected that the database
is in an inconsistent state' message. Then if I click 'OK' to repair it, I
get a 'This is not an MS Access database' message. I am not using a front-end
or back-end server. This is a very simple database on my home computer. I
cannot use the Access 'compress and repair' facility because the db has to be
open to use it. How can I get my database back in working order!

You can run a compact/repair without opening the database by using a
command line switch.

Create a shortcut and for the target use: "c:\program files\office
11\msaccess.exe" "c:\pathtodatabase\database.mdb" /repair

You'll have to replace the two parts in quotes with the actual path to
your Access executable and database, but that's not too hard.

Keven

 

[Gina Whipp]

CompGeek78,

I hesitate to tell someone who may have a corrupt database to run Comapct &
Repair. Sometimes that does more damage then good. I let them run thru the
*steps* to repair the database as Compact & Repair RARELY fixes the message
the OP got.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have an Access 2007 database that was working just fine until the
computer's power plug came loose while I was using the database. Now, when
I
try to open the database, I get the 'MS Access has detected that the
database
is in an inconsistent state' message. Then if I click 'OK' to repair it, I
get a 'This is not an MS Access database' message. I am not using a
front-end
or back-end server. This is a very simple database on my home computer. I
cannot use the Access 'compress and repair' facility because the db has to
be
open to use it. How can I get my database back in working order!

You can run a compact/repair without opening the database by using a
command line switch.

Create a shortcut and for the target use: "c:\program files\office
11\msaccess.exe" "c:\pathtodatabase\database.mdb" /repair

You'll have to replace the two parts in quotes with the actual path to
your Access executable and database, but that's not too hard.

Keven

 

[Arvin Meyer [MVP]]

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[John Spencer]

First thing I would try is to see if there is an open lock file for the
database and if there is attempt to delete the lockfile.

Before you attempt anything else - make a backup copy of your database.

Then try a compact and repair. If that doesn't work then try the various
recovery steps posted on Allen Browne's site and Tony Toews recommendation.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Leec]

Thank all of you for your suggestions! However, I tried each one of them only
to be thwarted by Access 2007! Access 2007 creates 'accdb' files, not 'mdb'.
The repair will not work no matter what. I tried to import the objects which
did not work either. The db is too big to recreate all over again. With that
said, can any of you recommend a good, reliable tech company that can try to
repair my db?

 

[Gina Whipp]

Arvin's reply gave you a source...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm