ADO » Recordset » CursorLocation

CursorLocationEnum = recordsetobject.CursorLocation
recordsetobject.CursorLocation = CursorLocationEnum

Sets or returns a long value that is a CursorLocationEnum value which defines the location of the cursor engine (server-side or client-side).

The CursorLocation property sets or returns one of the CursorLocationEnum constants that specifies the location of the cursor library. In reality, there are only two choices, client-side or server-side. Typically, client-side cursors are more versatile. However, the default is to the server-side.

You cannot change the cursor library for a Recordset while it is open.

CursorLocationEnum Constants

Constant Value Description
adUseClient 3 Use client-side cursor supplied by the local cursor library
adUseClientBatch 3 Obsolete, same as adUseClient
adUseNone 1 Obsolete, no cursor service
adUseServer 2 Default, use the cursor supplied by provider or database


Set objRecordset = Server.CreateObject("ADODB.Recordset")
Set objRecordset.ActiveConnection = strConnection
objRecordset.CursorLocation = adUseClient
objRecordset.CursorType = adOpenDynamic
objRecordset.Open "ChantList", , , , adCmdTable

See Also: