>I have an existing app that uses a MSSQL 7 backend and ODBC to access the data. I'm also using NT 4.0 SP6a WS and Server, latest IE, and VFP7 SP1.
>
>Today, I have been approached by our sales people to add into the app, the ability to run the app disconnected from the network (i.e. in a car on the road, in flight, etc.). When they have a chance to connect to the database, it needs to be able to synchronize the data.
>
>My first thoughts are to take advantage of the VFP database engine to get and hold a subset of the apps data that would pertain to sales (i.e. customer data, job data, etc.). Let them change/add to this local data and update these changes when they reconnect to the network.
Did you check "offline views" in the help file?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)