I don't know what type of connection you are using; however, the most likely
culprit is an incorrect cursor type. Take a look at the cursor type setting.
Or you could try moving to the first and then to the last of the recordset
before doing the add (again this indicates an incorrect cursor type).