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

How about to add linked server to your data:

EXEC sp_addlinkedserver
     @server = N'YourVFPServer', -- Your linked server name here
     @srvproduct=N'VFP9',        -- can be anything
     @provider=N'VFPOLEDB.1',    
     @datasrc=N'"\\pjkserver\data\apps\app1\data\YourDBC.dbc"' -- Full path to your database

update MYVFPSERVER...mytable SET Active=0 where pkref = 'E10295'

NOT TESTED