O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

F.2. Recordset.Open Method Options

The Open method of the Recordset Object can take several different enumerations, the details of which are described in the following tables.

F.2.1.

F.2.1.1. CursorTypeEnum Members
MemberValueDescription
adOpenUnspecified−1Hidden. No cursor type is specified.
adOpenForwardOnly0Default. Specifies a forward-only cursor. This is similar to a static cursor, except that you can only scroll forward through the records.
adOpenKeyset1Specifies 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.
adOpenDynamic2Specifies 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.
adOpenStatic3Specifies a static cursor. This cursor type is read-only, and additions, deletions, and modifications made by other users are invisible in your recordset.
F.2.1.2. LockTypeEnum Members
MemberValueDescription
adLockUnspecified−1. A lock type is not specified. Clones are created with the same lock type as their original.
adLockReadOnly1Specifies a read-only recordset.
adLockPessimistic2Specifies pessimistic locking at record-level.
adLockOptimistic3Specifies pessimistic locking at record-level. The record is locked only when you call the Update method. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required