CursorDriverEnum enumeration (DAO)
Applies to: Access 2013, Office 2013
Specifies the type of cursor driver.
Name |
Value |
Description |
|---|---|---|
dbUseClientBatchCursor |
3 |
Always uses the FoxPro Cursor Library. This option is required for performing batch updates. |
dbUseDefaultCursor |
-1 |
(Default) Uses server-side cursors if the server supports them; otherwise uses the ODBC Cursor Library. |
dbUseNoCursor |
4 |
Opens all cursors (that is, Recordset objects) as forward-only type, read-only, with a rowset size of 1. Also known as "cursorless queries." |
dbUseODBCCursor |
1 |
Always uses the ODBC Cursor Library. This option provides better performance for small result sets, but degrades quickly for larger result sets. |
dbUseServerCursor |
2 |
Always uses server-side cursors. For most large operations this option provides better performance, but might cause more network traffic. |