ADO » Connection » CursorLocation

long = connectionobject.CursorLocation
connectionobject.CursorLocation = long

Sets or returns a long value used to select between various cursor libraries accessible through the provider.

The CursorLocation property establishes the cursor location and services. It sets or returns a long value that is one of the CursorLocationEnum constants. The default is adUseServer, or 2. Server-side and client-side provided cursor services usually add increased flexibility.
CursorLocationEnum Constants

Constant Value Description
adUseClient 3 Uses a client-side cursor provided by the local library
adUseClientBatch 3 Obsolete
adUseNone 1 Obsolete
adUseServer 2 Uses a server-side cursor provided by the local library


objConnection.CursorLocation = adUseServer

See Also: