Row cannot be located for updating some values
You'll be able to ask questions about accountancy, tax and audit or chat with the community and help others.OLE DB provider "MSDASQL" for linked server "PRESTA" returned message "Row cannot be located for updating. The client side is vb6 and using Dcom dll's hosted on the db server. I have a table which has oninsert trigger When the recordset is updated in the com class it throws the foll error : "Row cannot be located for updating. Some values may have been changed since it was last read.".Msg 7343, Level 16, State 4, Line 1 The OLE DB provider "MSDASQL" for linked server "PRESTA" could not UPDATE table "[PRESTA].. The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized. My theory is that the recordset is not currently insync with the DB table. This is code giving me the error: Sounds like you are using a static or keyset cursor, and either no primary key for the table, or the primary key is somehow being changed.
After Disabling this Constraint my code worked like a charm! Just for my records in order to manage to find the cause I simulate the error with a small new table, having the identity on it.
Do you have two or more clients updating the database at the same time, or are you modifying the data from multiple places in the same app and not keeping track of it? When I get to step 4 I am saving this mess I have produced.
Originally posted by Thinker Sounds like you are using a static or keyset cursor, and either no primary key for the table, or the primary key is somehow being changed. Access protests to this and returns the error, 'Row cannot be located for updating.' I can better display this with a few textual graphics. Ive had this error come up from time to time when using a check box on a Data Grid.
The recordset still thinks record 2 is there, (not knowing it has been deleted yet). With a Keyset cursor and optimistic/pessimistic locking, a deleted record should be removed from the recordset. Add New method, it creates a new record, however, until you do the .
Is there any way for me to check if a record has been deleted then .update the record set if such an event has taken place? There is an Edit Mode property to tell you the current state of the current record, and Cancel Update method to stop a pending update. Cursor Type = ad Open Dynamic, isn' t doing anything. Delete method on a row in the recordset, it is gone in the database.