Pascal,

With VFP you can write a out-of-process automation server (See VFP documentation
). When you place the server application on the remote machine and communate with this server.

THe advantage is that the server application runs on the remote machine. So the client only gives the server commands which are processed on this remote server. You can process very complex queries on the server and send the result back to the client.

In this way you cannot only minimize the network trafic (since only resultsets are send to the client, not whole tables from which the resultset is to be extracted) but also create an abstract level in your application and secure the underlying tables (the server app has other user rights than the client)

Regards,


Walter