A Recordset without a live connection to a database server is called a disconnected Recordset. You can create a disconnected Recordset using the CursorLocation Recordset object property. The CursorLocation property allows you to specify whether to use client or server cursors and, most importantly, allows changes to be made in a batch mode. This example demonstrates how to create a disconnected Recordset:
Public Function GetDisconnectedRecordset() as Object Dim objConnection as New ADODB.Connection Dim objRecordset as New ADODB.Recordset objConnection.Open "DSN=MyDSN;UID=sa;PWD=;" objRecordset.CursorLocation = adUseClient objRecordset.Open "Select * From Authors", objConnection, adOpenUnspecified, adLockUnspecified Set GetDisconnectedRecordset = objRecordset End Function 
