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. |