
ADO not releasing row level lock after .Update
I am using SQL Server 7 with ADO 2.5. I am opening a recordset with the
following code:
Set rst = New ADODB.Recordset
With rst
.CursorLocation = adUseServer
.CursorType = adOpenDynamic
.LockType = adLockPessimistic
.Open "Select * from tblLibraryIndexPoint Where id = 1", Conn
End With
When I call rst!Name = 'John' the record is been locked (which is correct).
However when I call rst.Update the lock is not been released. It is not
released until I close the recordset. I have tried using different isolation
levels on the connection object.
Does anybody know why and how I can force the lock to be released without
closing the recordset?