Updating a recordset
I just downloaded mysql-connector-odbc-3.51.12, and I am still seeing the problem. Re-opening this old bug -- we need to figure out how to resolve this (and there are later duplicate filings). Connection, ad Open Dynamic, ad Lock Optimistic, ad Cmd Table rs.
The problem is prevalent when you have another exit condition in mind for your loop, so you are not thinking of EOF.
This article highlights ten common traps with DAO recordsets in VBA code.
Most of the traps yield no syntax error; they are bugs lying dormant in your code until particular conditions are met.
Open Table Name, Cnn, ad Open Forward Only, ad Lock Optimistic RS.
Add New RS("Unique")=1 RS("Limit")=2 RS("Desc")="Error Test" RS.