>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 ?

Hi Pete,
This works (but still gives an error):

select * from openrowset
('vfpoledb.1','\\pjkserver\data\apps\app1\data';'';'','update myTable set active = 0 where pkref = "E10295"')

Cetin