Create a Disconnected Recordset

Create a Disconnected Recordset

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 
See also  Why ChatGPT Is So Important Today

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist