Access 2002 Programming by Example

Cursors and Cursor Types

An ADO cursor maintains the query result recordset for browsing. In fact, a cursor is sometimes called a recordset. The current position in the recordset is provided for forward and backward scrolling.

Cursors have three purposes in ADO. First, the cursor determines movement within the recordset and whether the recordset will reflect user changes. Second, the cursor determines the storage location of the recordset while the cursor is open. Third, the cursor’s locking type determines how the ADO datastore will lock the records when they are changed.

ADO provides four cursor types, as shown in Table 12.5.

Table 12.5. ADO Cursor Types

Type	Function
Static cursor	Provides a static copy of a set of records that allows all ...