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.