Printable View
I want to isolate my updates in transactions, And I am updating multiple tables
Everything goes ok on the first table , but when i update the next, i got error: 'Could not update; currently locked.'
I am using ado (the ado-connection begintrans/commit/rollback)
Do anybody know why, and how to avoid this error???
I am not sure if this will answer your question, but I will try.
It sounds like you have a recordset open to the table that you are trying to update when you get the error. If you are attempting to update information to that table when you have a currently open recordset, the table will be locked and you will not be able to perform the update. Make sure you are closing all recordsets as soon as you no longer need the information in them.