>I want to be able to use parameterized views from a FoxPro dbc located on a LAN server with minimumal bandwidth usage. What is the most efficient way to communicate between client and server to retrieve data. I think ADO and OLEDB are the key but don't know how to make them work with parameterized views. I have viewed Thread #494019 Message #494233 but couldn't view any data, if it was loaded into the recordset.

It's misconception that accessing VFP data on file server through ODBC or ADO can reduce amount of data transfered between file server and workstation. All data processing's still done on workstation because ODBC driver and ADO provider are running on the workstation not on the server.