Hi, Christoph!

I got a similar problem as you had when handling with ADODB.Recordsets 
based on multiple joined 

SQL queries (or views).

Although you wrote that your problem appeared after upgrading MDAC, you 
could try to solve your 

problem by doing the following:

Specify the ADODB.Recordset's "Unique Catalog" and the "Unique Table" 
properties before calling 

the ADODB.Recordset.Update, -.Delete, -.ADD or -.Insert methods:

        oRS.Properties.Item("Unique Catalog").Value = "DatabaseName"
        oRS.Properties.Item("Unique Table").Value = "TableName"

When calling the ADODB.Recordset.Resync method, you additionally have to 
specify a "Resync 

Command". That command could be an appropriate stored procedure in your 
database:

        oRS.Properties.Item("Resync Command").Value = "EXEC 
ResyncStoredProc ?"

For additional information refer to: 

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q251021


Regards,

	Bernie.





> Hi,
> 
> Methods Update and Resync of a recordset work with MDAC 2.0.
> Now, with MDAC 2.1 I have the error:
> 
> Run Time Error '-2147217885(80040e23)':
> The key value for this row has been changed or delelted at the data 
> source. The local row is now deleted.
> 
> Does anyone know how to solve the problem ?
> 
> Thanks.