I'm using VB 6 SP5 with an Access 97 database. Here's the scenario:
I call AddNew on a recordset, change some fields in the recordset and then call Update. The recordset is still on the same row and then I change one of the fields, and then call Update again. When I do this, I get:
Run-time error -2147217864, row cannot be located for updating
It appears that this error only happens after I have called update after calling AddNew. If I call Update on an existing record, the error does not occur.
I tried calling Requery after AddNew and Update, but this moved the position to the first row in the recordset.
I call AddNew on a recordset, change some fields in the recordset and then call Update. The recordset is still on the same row and then I change one of the fields, and then call Update again. When I do this, I get:
Run-time error -2147217864, row cannot be located for updating
It appears that this error only happens after I have called update after calling AddNew. If I call Update on an existing record, the error does not occur.
I tried calling Requery after AddNew and Update, but this moved the position to the first row in the recordset.