D
Developer Seeking for Help
Hi, I have a client application running on two computers.
If I use one computer to execute an update to a record and
then use the other computer to execute another update to
the same record, I would get the following error message:
"Row cannot be located for updating. Some values may have
been changed since it was last read."
My recordset has the following properties:
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockPessimistic
I have tried rs.requery and close then open rs but they
did not work. Doing these would give me this error
message: "Operation is not allowed in this context."
This is a synchronization issue but I don't know how to
resolve it using VBA.
Does anyone know how this problem can be resolved? Some
sample codes would be appreciated. Thanks.
If I use one computer to execute an update to a record and
then use the other computer to execute another update to
the same record, I would get the following error message:
"Row cannot be located for updating. Some values may have
been changed since it was last read."
My recordset has the following properties:
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockPessimistic
I have tried rs.requery and close then open rs but they
did not work. Doing these would give me this error
message: "Operation is not allowed in this context."
This is a synchronization issue but I don't know how to
resolve it using VBA.
Does anyone know how this problem can be resolved? Some
sample codes would be appreciated. Thanks.