This documentation is archived and is not being maintained.

RecordsetOptionEnum Enumeration

Office 2007
Used with the OpenRecordset method to specify characteristics of a new Recordset object.
NameValueDescription
dbAppendOnly8Allows user to add new records to the dynaset, but prevents user from reading existing records.
dbConsistent32Applies updates only to those fields that will not affect other records in the dynaset (dynaset- and snapshot-type only).
dbDenyRead2Prevents other users from reading Recordset records (table-type only).
dbDenyWrite1Prevents other users from changing Recordset records.
dbExecDirect2048Executes the query without first calling the SQLPrepare ODBC function.
dbFailOnError128Rolls back updates if an error occurs.
dbForwardOnly256Creates a forward-only scrolling snapshot-type Recordset (snapshot-type only).
dbInconsistent16Applies updates to all dynaset fields, even if other records are affected (dynaset- and snapshot-type only).
dbReadOnly4Opens the Recordset as read-only.
dbRunAsync1024Executes the query asynchronously.
dbSeeChanges512Generates a run-time error if another user is changing data you are editing (dynaset-type only).
dbSQLPassThrough64Sends an SQL statement to an ODBC database (snapshot-type only).


Show: