ADO Synchronisation Service

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.

I've found the solution to my problem.

In case anybody else is interested, my problem was caused by the fact that when my recordset is based on a query that involves outer joins, the unique table (the one to update) needs to be specified. It is done like this:

rsSource.Properties("Unique Table") = <Table Name>

There you go.

Simon.