I am having problems with the .Resync method of the ADO recordset object (ADO 2.6).

When I attempt to resync with the datasource and changes have been made at the datasorce by someone else I get the following RT error:

'Key value for this row was changed or deleted at the data store. The local row is now deleted'.

I know for a fact that the record still exists and that the key field (the primary key) has not changed.

All I want to do is overwrite my recordset with the current values in the data source but this won't let me.

By the way, I don't want to do a 'Requery' if I can help it.

Thanks,

Simon.