error 3197 - query fails

[ooops]

Hi all,

I got the message "The Microsoft Jet database engine stopped the process b/c you and another user ate attempting to change the same data at the same time - Error 3197 "

My Access database is in my local drive and I really don't understand how this happens and please help me to fix the problem. I got the above error when i do query for a certain fields only, with others it's fine. Thank you so much for your help.
Sincerely,
Bao Nghi

 

[tlbroadbent]

Are you updating Access tables only or linked SQL tables? If linked SQL tables check thread181-122291 for a possible solution. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.