FILE LOCKING IN SQL DATABASE - ERROR 3197

A

AndrewDB

Hi All, I really will appreciate help in this one. I have an Access 2007
client linked to a MySQL database which I connect to using ODBC. At times
when updating a recordset I get a Error 3197 "You and another user are trying
to update the same record at the same time". This does not occur all the
time. But this is a standalone system not on a network and I have no other
links to the recordset at the time.

How do I overcome this?
 

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