I've been scratching my head with this. I'm using a select query
to locate a record from a table based upon its primary key.
I then set some field values to those returned from a web page
form. I then do a recordset.update.

If the web form details differ from the saved values in the database
then the update works just fine. If they are the same, an error is
returned, being

"Query-based update failed because the row to update could not be found."

Now, I know this is not the generally accepted way to do things, but I
still want to know why it fails... I've tried all combinations of cursors
and locks. It's totally retarded in my opinion.

any thoughts?

regards,

paolo