Row cannot be located for updating some values may have online dating for cops
you said you want to update row but updated_row_count returned was 0 (as there was nothing to update).This occurs since first option in DSN config ("Return Matching Rows") is not checked even we say clearly it should be in manual.
This blog explains an issue you're likely to face while executing a remote UPDATE query against a My SQL server over a linked server connection using ODBC DSN based connectionstring Recently I was working in a project where I required data to be transferred from a remote server and do some manipulations with it.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. I am getting the above runtime error "Row cannot be located for updating. This problem is becuase of deletion of row which you are trying to update.The error always occurs on an edit of a record selected from the grid. when populating controls and updating same on a Save. The Server is an NT server, and the workstations run under Windows 98.The present coding pattern is as follows: Open the record set using the DE. Address the DE.recordset when populating the controls on the edit form and update the DE.from the controls on a Save. Getting everyone out and repairing/compacting the always makes the problem disappear for a while. The problem can only very rarely be duplicated when running the app from VB, and the few times it has occurred, the .update was the highlighted line.