I have a very strange problem and I can't figure it out. I am using VB6, ADO and Oracle and I am updating fields through the recordset (AddNew, Update methods). I deployed an early version of the app, and it was working fine. I transfered around 600 records from an excel spreadsheet, and the users had to go through all of them and change some fields. For some reason, when a user tried to update a specific record she was getting the following error:
"Row cannot be located for updating. Some values may have been changed since it was last read."
This happened only for one record. Everything else were okay! Nothing special with that record. The way my editing works is like this:
1)User clicks edit button: the textboxes, combos become enabled.
2)User enters data and clicks save: all fields get the values from textboxes, combos and recordset gets Updated. That is editing in my application is the same as saving a new record (it calls the same function).
I don't know if this is the right way...
Anyway, I found out that when two fields where not updated, it was okay. But those two fields contained information that most of the other fields had too!
I am only hoping now that it won't happen again. Thanks for any hints on this.