If you must reply off-line, then remove the "NO SPAM" On Tuesday, May 01, 2007 AM Jan Hyde (VB MVP) wrote: Re: Error Row cannot be located for updating.Some values may have been changed since it was last read "fniles" 's wild thoughts were released on Mon, -0500 bearing the following fruit: Since your using optimistic locking your *hoping* no-one else will change the record before you do.There is no direct equivalent for the Visual Basic 2008 The following tables list Visual Basic 6.0 properties, methods, and events, along with their Visual Basic 2008 equivalents.Those properties, methods, and events that have the same name and behavior are not listed.My friend I face same problem,you can solve it by code don't use recordset to update your record try to make it coding Ex: Sql="Update My table Set Myfiled=New Data Where Mykey=Updated Key" Db.excute Sql I hope if it'll help fniles wrote: Error Row cannot be located for updating. Update method I get the error -2147217864 (Row cannot be located for updating.Some values may have been changed since it was last read 30-Apr-07 I am using VB6 connecting to a SQL Server 2005 database using ADO. Some values may have been changed since it was last read).
Update method I get the error -2147217864 (Row cannot belocated for updating.
If your table does have a primary key, the problem can also be caused by not including the primary key field(s) in the select clause of the query used to open the recordset.
This sample chapter from David Sceppa's "Programming ADO" book will help you understand why the error can occur: Microsoft MVP - ASP/ASP. This email account is my spam trap so I don't check it very often.
Some values may have been changed since it was last read." Huh? Properties("Update Resync") = ad Resync Auto Increment MRS.
Seems like this only happens if I change the value of a numeric that used to be null. String Field="String" does not cause problem when I update RS! Using Access2000, RS is opened as follows: Set WODB = New Connection WODB. Open "Select * FROM Orders", WODB, ad Open Static, ad Lock Pessimistic MRS.