Edit

Share via

CursorDriverEnum enumeration (DAO)

  • Article

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.