error 3197 - query fail

[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.
Helen Sincerely,
Bao Nghi

 

[Karl Blessing]

it would help to see the line in your program where you are opening the connection, and/or opening the recordset, it is likely you have a certain type of Lock on the database, that doesnt allow you to have Access open at the same time you are running your application. Karl Blessing aka kb244{fastHACK}