OK but you don't absolutely need to do that with T_SQL or using VFPOLEDB driver.
1) Instead of T-SQL update via a linked server, use a remote view in VFP to update local data. You can take data offline and online.
2) Instead of VFPOLEDB use 'Advantage Database Server' driver. It can read write VFP tables and would behave as a layer between SQL server and VFP (I didn't test with such a configuration but in theory it should work).
http://devzone.advantagedatabase.com/dz/content.aspx?Key=20&Release=12Cetin
>You would if you were in my shoes.
>
>When you have an old Clipper (sic!) application that you are -slowly- porting to SQL Server with a VFP front end, and have part of the app running in the new - and part in the old setup, with, I might add, the need to have your data consistent at one level or another, I'm quite sure that you also would see the need to update the old stuff with the new.
>
>That's just the way the cookie crumbles.
>
>:-)
