Row cannot be located for updating some values may have

Some values may have been changed since it was last read.Here is the entire error message: "Error -2147217864. Some values may have changed since it was last read." I have written a system for a small business using VB with and .

Despite the usual minor errors in the code which occur with any new software, the system is solid, effective, and meets the business objectives---were it not for his error.

The status column in the remote server table have to be updated later.

The remote server in this case was My SQL server and we were using ODBC DSNs based connectionstring.

Tentative conclusion: something in either the Data Environment or the code is allowing the to get corrupted. But it also occurs sometimes when the edit form is first called, before any .updates are attempted.

an article explaining ADO "behind the scenes" and why you may be receiving this error:

Open "SELECT * FROM Customers", cn NWind, _ ad Open Static, ad Lock Optimistic, ad Cmd Text rs Customers. No feedback was provided for this bug for over a month, so it is being suspended automatically.

Please or register to post comments
If spammers comment on your content, only you can see and manage such comments Delete all
Thread • Row cannot be located for updating. Some values may have been changed since. Nabil Francis 18 Mar 
21-Nov-2018 18:22
Reply

Row cannot be located for updating some values may have introduction

Row cannot be located for updating some values may have

Recent posts

21-Nov-2018 23:16
22-Nov-2018 07:33
22-Nov-2018 09:55