Error 3197-Jet database stopping file opening

J

Jessica Gartner

Hiya,
I have an access database that I cannot open today but it
worked fine yesterday. I am the only one in our LAN who
has Access and I am sure that nobody else is editing
records. I can't find anything in the knowledge base
that applies to this situation. I have tried Compact and
Repair and I get the same error as when I try to open the
file. Is there anything I can do?
Thanks
Jessica
The error help is below
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)
This error can occur in a multiuser environment.

Another user has changed the data you are trying to
update. This error can occur when multiple users open a
table or create a Recordset and use optimistic locking.
Between the time you used the Edit method and the Update
method, another user changed the same data.

To overwrite the other user's changes with your own,
execute the Update method again.
 
T

Tony Toews

Jessica Gartner said:
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)

Sign of corruption and misleading error message.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top