3197: The microsoft Jet Database Engine stopped the process because you and another user are attempt

[josiah.mcdonald]

Hello,

I have a fairly large (For Access - its slated to be transferred to
MySQL) backend that allows the user to use the database's front end
normally to store and retrieve data. However when I try to open the
database I get the Error "The microsoft Jet Database Engine stopped
the process because you and another user are attempting to change the
same data at the same time".

This isn't true because I have it on my local computer.

I've tried importing to a new DB file and I get the same error. The
original DB will not open to allow import (show table list) and show
error message in subject line of this post.

I've been reading through other forum posts and tried JetComp.exe and
that also gave me an error.

Also I've read that since the users can use the file normally its
probably an issue with one or more of the system tables. However no
one has addressed how to solve this case.

Can someone please help me as soon as possible as this DB file
contains very important information and if fails will cause the group
to be "Dead in the water"

Thanks in advance,


Josiah

 

[Gina Whipp]

Josiah,

Sounds like your database might be corrupt. If you weren't making any
back-ups make one now (You may need it!!! There are companies out there
that claim to be able to get your data. I personally have ever used one so
I cannot attest to their claim.)

Have you tried just importing one table at a time to a new database?

Have you tried select Tools... Database Utilities... Compact and Repair.
Does that help?

Also check out Tony's corruption FAQ:
http://www.granite.ab.ca/access/corruptmdbs.htm especially this page:
http://www.granite.ab.ca/access/corruption/symptoms.htm