From VFP help: "When you use Visual FoxPro OLE DB Provider as a SQL Server-linked server, only queries are supported. The Visual FoxPro OLE DB Provider does not support update, insert, or delete operations through a linked server". The OPENROWSET is ad-hoc linked server.

>Apols for double posting - under pressure :-)
>
>Hi All, I need to update some Fox tables from SQL Server 2000, here's what I've tried without success
>

>update openrowset
>('vfpoledb.1','\\pjkserver\data\apps\app1\data';'';'','Select active from mytable where pkref = "E10295"')
>Set active = 0
>

>
>
>I receive the error
>

>Server: Msg 7301, Level 16, State 2, Line 1
>Could not obtain a required interface from OLE DB provider 'vfpoledb.1'.
>OLE DB error trace [OLE/DB Provider 'vfpoledb.1' IRowsetChange::QueryInterface returned 0x80004002:  IRowsetChange].
>

>
>If I just execute the Select part it works fine - I have the latest VFPOleDB driver and am running XP pro Service Pack 2, any ideas ?