-
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.
-
It's OK, worry not...
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.