Inserting batch records in VB With Client Side Cursor

[Moises Franco]

Hello!!

Recently I've been working in a program that must insert about 2000 records in a table without user interaction using an ADODB Connection and a Recordset with the ODBC 3.51 driver and MySQL for nt 4.0.18. The Recordset is open with the adOpenStatic, AdLockOptimistic and AdCmdTable options.

After inserting two or three records this way (in batch mode), I get an error message telling me that the record cannot be written or updated because it has changed. That of course cannot be possible, since no one else is using the database and the record did not exist to begin with.

I will really appreciate your help.

Thank you!