Question:
I want to open a small ADO recordset from the server and save it the local drive to be used as a disconnected session. Can you tell how to do that?
Answer:
If you want to use the recordset in a disconnected state, meaning that it no longer has a connection to the server, use a client-side cursor and, after fetching the data, set the recordset’s ActiveConnection to Nothing.
To save the recordset to disk use the recordset’s Save method, and open it with the Open method passing the file name and adCMDFile for the options parameter.