Error Message 3197

[Guest]

I am trying to open a shared database the is opened by users exclusively, but
I am getting the following error message:
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time. (Error
3197)
The problem that I am running into is that none of the users are logged in
at this time and it seems that the database got locked. No one can access it
because this error is blocking everyone. How can I fix this error if I (the
administrator of the database) cannot access the database.

 

[Jeff Conrad]

in message:

I am trying to open a shared database the is opened by users exclusively, but
I am getting the following error message:
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time. (Error
3197)
The problem that I am running into is that none of the users are logged in
at this time and it seems that the database got locked. No one can access it
because this error is blocking everyone. How can I fix this error if I (the
administrator of the database) cannot access the database.

Error 3197 *usually* indicates some kind of corruption:
http://support.microsoft.com/default.aspx?id=182867

The first thing, and easiest, to try is to see if there is a locking file
(LDB extension) with the same name as the database in the same
folder as the main database file. If there is one there, make sure no
one is using the database, and then try to delete the file. That might
get you back in.

I would seriously review the following information on corruption as
you may need this.

http://allenbrowne.com.au/ser-47.html

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

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry
(See Fix Corrupt Access Database v3.9 Document)

http://www.e-tech.ca/001-AccessFAQ.asp

http://www.everythingaccess.com/tutorials.asp?ID=0

ACC2000: How to Recover Data from a Corrupted Table by Using the DAO Method
http://support.microsoft.com/?id=815280

ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/?id=306204

ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=209137

ACC2000: How to Recover Data from a Damaged (Corrupted) Table
http://support.microsoft.com/?id=247771

ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=304561

Jetcomp utility available at:
http://support.microsoft.com/?id=273956

Good luck,