DefaultCursorType Property Constants

The DefaultCursorType settings for the Data control are:

Setting Value Description
vbUseDefaultCursor 0 Let the ODBC driver determine which type of cursors to use.
vbUseODBCCursor 1 Use the ODBC cursor library. This option gives better performance for small result sets, but degrades quickly for larger result sets.
vbUseServerSideCursor 2 Use server side cursors. For most large operations this gives better performance, but might cause more network traffic.