If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
FILE LOCKING IN SQL DATABASE - ERROR 3197
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? |
Thread Tools | |
Display Modes | |
|
|