Mistake Conflict of operation of cursor -2147217885

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

Gentlemen are trying an application that worked with access for MSDE to
migrate and everything went well until that went to try to increase a
registration in a table. using the following code:

Dim MiRS As ADODB.Recordset
Set MiRS = New ADODB.Recordset
MiRS.CursorType = adOpenKeyset
MiRS.LockType = adLockOptimistic
MiRS.Open "Dev_F_Eventos", Conn, , , adCmdTable
MiRS.AddNew
MiRS!Usuario = Usuario
MiRS!Evento = NomedoEvento
MiRS.Update
MiRS.Close
Set MiRS = Nothing

This worked perfectly in the access and for the of ADO says it is correct,
but doesn't want to work gives following mistake: Conflict of operation of
cursor -2147217885
 
Back
Top