When I'm trying to update information in the database vb6 is fetching me the following error:-

"Row cannot be located for updating.
Some values may have been changed since it was last read."

what is the cause and remedies for the above error?

The reason for the error may be because the WHERE clause in the SELECT statement used
to create the recordset does not contain a primary key column. Therefore, when ADO
generates the UPDATE statement for the Update method, it cannot not use key column
information. Thus, the Update statement was not able to identify one particular
row to update.

The solution is to create your own UPDATE statements to include the key
column(s) and execute them using the EXECUTE method.

Let me know if this helps. Also, which database are you using?