Hi Scott ---
You don't want to change a view from local to remote. What you want to do is make all of your controls bound to a local view which has a source of either another local view or a remote view. Put in a "translation layer" for the data, basically.
>Is it possible to change the CursorSource at run-time from a local view to a remote view. Both views have to same structure expect one is from VFP and the other SQL Server. To the app the to cursors function the same. If I could change the source based on a indicator I could run the same application in for local data as I do remote.
>
>Thanks in advance
>
>
>Scott k
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05