ADO network usage

[Schroeder]

I've been using DAO to connect to Access databases. One thing I quickly learned is that the amount of communication involved with DAO limits its use to local networks. I started using the Winsock to send queries to and recordsets from the server in plain text.
Now I'd like to convert a program that has been running locally to enable it to run over a VPN. Rather than use my Winsock transfer method, I was hoping I could move to ADO. If I use ADO with a server-side cursor, will that limit the network usage so that my program will remain responsive even when connected via a VPN on a 56K modem?

 

[CCLINT]

The thing that needs to be understood, is that a client side server means that the ADO client cursor manager handles the cursor, and that locally. And a Server Side cursor means that the Provider handles the cursor....and the location of where the cursor is hanled is where the provider is located.
If JET is the provider, and the JET engine is on the client....

I would highly recommend using disconnected recordsets(get data and disconnect) and update the db using action queries, reconnecting the connection object only for the duration of retreiving data, and updating data.