>I have been using remote views is this a stable way to go? I am getting time out issues, etc. Is there another way to update Sql Server then using remote views, if so point me in the direction I need to go, or a simple sample if there is one so I can see what is going on.
>
>Thanks
Sure, but it depends what version of VFP you use.
If VFP7 and smaller you could use 2 ways, both ODBC based:
One you already use - RV, second is SQL-PASS through. Check all functions that begins with SQL*() in HELP
In VFP 8 and 9 you have one additional choice-to use CursorAdapters. That way you can use ODBC and ADO based RecordSets to manipulate data. Because CAs can use both technologies.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.