If VFP table is pre VFP7, you can use OLE DB provider for ODBC with VFP ODBC driver

UPDATE 
 OPENROWSET
	('MSDASQL','Driver={Microsoft Visual FoxPro Driver};SourceDB=\\\pjkserver\data\apps\app1\data;SourceType=DBF', 
	'Select active from mytable where pkref = "E10295"')
SET active = 0

>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 SP2, any ideas ?