Bug Error: "Row cannot be located for updating" using ADO

[sylvanst]

Using ADO, I'm getting a run-time error number -2147217864 that states: "Row cannot be located for updating. Some values may have changed since it was last read."

Article 300586 states that this is a known bug in VB6.0 enterprise and professional using the ActiveX Data Objects data control (ADODC) bound to a Microsoft Access table.

However, I'm getting this error using ADO and trying to have my VB app update a MS SQL Server table. The app reads the first record and on the .update command the error is returned. The record is updated to the table however.

Does anyone have any suggestions for workarounds or resolutions.

Thanks,

 

[jeepxo]

This sounds to me like a data input problem more then anything else.

By chance is there the possibility that in any of the data you are updating that there is a '?

As in someone's name...say Miles O'Brien?

What may be happening is the sql is breaking because of the ' in the data.


Simply a guess...but since it does 1 update I would say the problem is caused by the data itself