Error 3197 single user database

[Dr Pete]

I've looked through previous answer to this problem but cannot find one that
works.

I've had the usual message relating to this: The jet database engine stopped
because you and another user are attempting to the same data at the same time.

I'm using Access 2003 with Windows XP
I've tried opening holding the shift key down.
I've tried importing into another blank database but get the same error and
message.
I've tried using the repair database function but also get the same error
and message .

I think the problem may have ocurred because of a Power failure. I'd just
closed Access and thought it had finished compacting and shut when the power
failed.

 

[Arvin Meyer [MVP]]

Typically, this error occurs when you are trying to display (and edit) the
same data in 2 places, like within 2 forms. Trying to Drill down will often
cause this if you haven't saved the data on the first form yet.

 

[Dr Pete]

Thankyou for your reply.

As I said in my earlier message I had closed Access and I thought it had
finished saving the DB as I had my Windows desktop visible and this was when
the power supply failed. I appreciate that this may not have caused teh
problem but I mentioned it because I read somewhere that it may cause a
problem. Is there a way to solve this problem or even to get acces to th
tables etc so that I can salvage something.

Pete

 

[Arvin Meyer [MVP]]

Power supply failures will often cause database corruption, so if the
database was actually open when the failore occured, that is a likely
problem. Here is my standard advice on corruption:

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

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Robert]

Sir,
After reading these articles, I still can not get the corrupted db to open.
Could you suggest how to open one like this? Thank you, Robert

 

[Arvin Meyer [MVP]]

If you've tried ALL of the solutions below, you probably need an outside
source to use a hex editor to find and fix the corruption. I can recommend
the one listed below, but there are others. Just Google for "Access
corruption repair"
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Robert]

Sir,
I did try ALL as suggested -just can not get the db to open. tried to
change name and place db on different server. Still can not open. Used the
JET tool but still said I could not open the file, etc.
Will now try to go open source on Google and ACCESS Corruption repair.
This is very frustrating, but i apprecaite your advice.

If you think of another means so i can at least open the db and then look
via VBA into the record that may be corrupted and eliminate it, please email
me.
Thanks, Robert

 

[Arvin Meyer [MVP]]

Whatever you choose to do, be sure to make copies and work on those copies.
Working on the original of a corrupt database, can corrupt it beyond repair,
as can trying to open it in a program that autosaves, such as Word or Excel.
If you've done that, it is gone for good.

HTH, and Good luck.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Robert]

I guess i may not have communicated the real issue. I have not been able to
open this database to make ANY suggestions of a correction. I have cut and
pasted it into a new server and folder - i have tried to use the EXCEL tool -
i tried to rename it. I can not open this file to make it work at all. Is
there some way to open it so I can use the VBA tool and see what happened?

R

 

[Arvin Meyer [MVP]]

My guess is that it is corrupt beyond anything you can do to repair it. One
last try:

Create a new, empty database and try to import the data. If that doesn't
work, you will need to use a repair service. DO NOT try to open the file
with any other program. If you do, there is a very good chance that you will
corrupt it beyond anything that even a repair service can fix.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com