CursorType (Recordset Object) —
The CursorType property of the Recordset object allows you to specify or retrieve the type of cursor used to create the recordset.
An integer value representing the type of cursor to use for the Recordset object. It can be any of the following constants:
This is the default. A forward-only cursor, as its name implies, only allows movement forward from the current record. Otherwise this cursor type is identical to the static cursor. There is one exception to this, however: some data providers will allow you to call the MoveFirst method to move the current record pointer back to the first record in the database. This is the fastest cursor type.
In a keyset cursor, you cannot see new records added by other users, and you cannot access records that have been deleted by other users. You can, however, see the changes to records in your recordset made by other users. All types of movement are possible in a keyset cursor recordset.
Dynamic cursors are the most flexible (and slowest) of the four types. In a dynamic cursor, additions, changes, and deletions are all visible in your recordset. All types of movement are possible in a dynamic cursor recordset.
Static cursors provide a static snapshot of the records in your recordset. This is useful for generating reports, but the records in the recordset are not updateable. Additions, ...