hi i know you are all good programmers out there but can somebody help me out please!!!!! i'm using mysql at the back end and vb on the frontend with odbc connection.
i have got this table with the key field "auto increment" the problem is when i make changes in any of the row in the recordset and try to update it, gives me this error :

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

but when i add a new row in the recordset and update the record it doesnt give any error and create a new record??????????