>>Doug,
>>
>>You can cr4ate a VFOP OLE Server application to run on the data server and provide services to your interface. The server would execute its queries on teh same machine that ahs the data and only send to the interface the required data. This gets rid of the cdx file crossing the network.
>
>This doesn't seem viable as a replacement for local and remote views. We're talking about a form that opens views in its data environment, and has controls that are bound the various fields of the views. To implement this concept I don't think I could use views in a way that would be compatible with using SQL Server as the back end.

Doug,

This is certainly the best way to provide scalability. When you move to SQL Server you onle need to change the VFP Server, the interface doesn't have a clue where the data is comming from. It sks the server for data and the server gives it the data it asked for, the interface knows nothing about where the data is comming from. Using a VFP server this way is true N-Tier system design.