Mistake Conflict of operation of cursor -2147217885

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Record in Form Click Event 5
Exporting data with vba from Excel to an Access 2007 db with password 8
How to use SQL Server connection string 0
Access + Dates = Nightmare 6
Update Table from Form 6
Bad arguments when opening SQL table for ADD 1
Bad argument when opening SQL table for ADD 1
Binding a form to a disconnected recordset and making it capable to update such recordset 2

Top