ADO Synchronisation Service

[simonm]

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.

[simonm]

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.