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???