Access 2003 VBA Programmer's Reference

J.2. Recordset.Open Method Options

There are 30 Win32 Registry functions that you can use from VBA. This section describes only 25 of them, because the remaining five require specialist knowledge of Windows security, which is well beyond the scope of this book.

J.2.1. CursorType Argument Options (CursorTypeEnum Values)

Constant	Value	Description
AdOpenUnspecified	−1	Hidden. No cursor type is specified.
AdOpenForwardOnly	0	Default. Specifies a forward-only cursor. This is similar to a static cursor, except that you can only scroll forward through the records.
AdOpenKeyset	1	Specifies a keyset cursor. This is similar to a dynamic cursor, except that records added by other users are not reflected in your recordset; however, records that other users delete are inaccessible in your recordset.
AdOpenDynamic	2	Specifies a dynamic cursor. In this cursor type, all additions, deletions, and modifications made by other users are visible in your recordset, and all types of row movement are allowed. If the provider supports bookmarks, they too are allowed.
AdOpenStatic	3	Specifies a static cursor. This cursor type is read-only, and additions, deletions, and modifications made by other users are invisible in your recordset.

J.2.2. LockType Argument Options (LockTypeEnum Values)

Constant	Value	Description
AdLockUnspecified	−1	Hidden. A lock type is not specified. Clones are created with the same lock type as their original.
AdLockReadOnly	1	Specifies a read-only recordset.
AdLockPessimistic	2	Specifies pessimistic locking ...