RecordsetTypeEnum Enumeration

Access Developer Reference

Used with the Type property to specify the type of Recordset object.

Name Value Description
dbOpenDynamic 16 Opens a dynaset-type Recordset
dbOpenDynaset 2 Opens a dynaset-type Recordset
dbOpenForwardOnly 8 Opens a forward-only type Recordset
dbOpenSnapshot 4 Opens a snapshot-type Recordset
dbOpenTable 1 Opens a table-type Recordset