acRecordsetOptionEnum

NameValueDescription
dbAppendOnly 8 Allow a user to add new records to the dynaset, but prevent the user from reading existing records.
dbConsistent 32 Apply updates only to those fields that will not affect other records in the dynaset (dynaset- and snapshot-type only).
dbDenyRead 2 Prevent other users from reading Recordset records (table-type only).
dbDenyWrite 1 Prevent other users from changing Recordset records.
dbExecDirect 2048 Execute the query without first calling the SQLPrepare ODBC function.
dbFailOnError 128 Roll back updates if an error occurs.
dbForwardOnly 256 Create a forward-only scrolling snapshot-type Recordset (snapshot-type only).
dbInconsistent 16 Apply updates to all dynaset fields, even if other records are affected (dynaset- and snapshot-type only).
dbReadOnly 4 Open the Recordset as read-only.
dbRunAsync 1024 Execute the query asynchronously.
dbSeeChanges 512 Generate a run-time error if another user is changing data you are editing (dynaset-type only).
dbSQLPassThrough 64 Send an SQL statement to an ODBC database (snapshot-type only).

“I am by heritage a Jew, by citizenship a Swiss, and by makeup a human being, and only a human being, without any special attachment to any state or national entity whatsoever” ~ Albert Einstein

Related:

OpenRecordset - Create a new Recordset.


© Copyright SS64.com 1999-2013
Some rights reserved