ADO enumerated constants

Applies to: Access 2013, Office 2013

To assist in debugging, the ADO enumerations list a value for each constant. However, this value is purely advisory, and may change from one release of ADO to another. Your code should only depend on the name, not the actual value, of each enumerated constant.

Enumerated constant	Description
ADCPROP_ASYNCTHREADPRIORITY_ENUM	For an RDS Recordset object, specifies the execution priority of the asynchronous thread that retrieves data.
ADCPROP_AUTORECALC_ENUM	Specifies when the MSDataShape provider re-calculates aggregate and calculated columns in a hierarchical Recordset.
ADCPROP_UPDATECRITERIA_ENUM	Specifies which fields can be used to detect conflicts during an optimistic update of a row of the data source with a Recordset object.
ADCPROP_UPDATERESYNC_ENUM	Specifies whether the UpdateBatch method is followed by an implicit Resync method operation and if so, the scope of that operation.
AffectEnum	Specifies which records are affected by an operation.
BookmarkEnum	Specifies a bookmark indicating where the operation should begin.
CommandTypeEnum	Specifies how a command argument should be interpreted.
CompareEnum	Specifies the relative position of two records represented by their bookmarks.
ConnectModeEnum	Specifies the available permissions for modifying data in a Connection, opening a Record, or specifying values for the Mode property of the Record and Stream objects.
ConnectOptionEnum	Specifies whether the Open method of a Connection object should return after (synchronously) or before (asynchronously) the connection is established.
ConnectPromptEnum	Specifies whether a dialog box should be displayed to prompt for missing parameters when opening a connection to an ODBC data source.
CopyRecordOptionsEnum	Specifies the behavior of the CopyRecord method.
CursorLocationEnum	Specifies the location of the cursor engine.
CursorOptionEnum	Specifies what functionality the Supports method should test for.
CursorTypeEnum	Specifies the type of cursor used in a Recordset object.
DataTypeEnum	Specifies the data type of a Field, Parameter, or Property.
EditModeEnum	Specifies the editing status of a record.
ErrorValueEnum	Specifies the type of ADO run-time error.
EventReasonEnum	Specifies the reason that caused an event to occur.
EventStatusEnum	Specifies the current status of the execution of an event.
ExecuteOptionEnum	Specifies how a provider should execute a command.
FieldEnum	Specifies the special fields referenced in a Record object's Fields collection.
FieldAttributeEnum	Specifies one or more attributes of a Field object.
FieldStatusEnum	Specifies the status of a Field object.
FilterGroupEnum	Specifies the group of records to be filtered from a Recordset.
GetRowsOptionEnum	Specifies how many records to retrieve from a Recordset.
IsolationLevelEnum	Specifies the level of transaction isolation for a Connection object.
LineSeparatorsEnum	Specifies the character used as a line separator in text Stream objects.
LockTypeEnum	Specifies the type of lock placed on records during editing.
MarshalOptionsEnum	Specifies which records should be returned to the server.
MoveRecordOptionsEnum	Specifies the behavior of the Record object MoveRecord method.
ObjectStateEnum	Specifies whether an object is open or closed, connecting to a data source, executing a command, or fetching data.
ParameterAttributesEnum	Specifies the attributes of a Parameter object.
ParameterDirectionEnum	Specifies whether the Parameter represents an input parameter, an output parameter, or both, or if the parameter is the return value from a stored procedure.
PersistFormatEnum	Specifies the format in which to save a Recordset.
PositionEnum	Specifies the current position of the record pointer within a Recordset.
PropertyAttributesEnum	Specifies the attributes of a Property object.
RecordCreateOptionsEnum	Specifies for the Record object Open method whether an existing Record should be opened, or a new Record should be created.
RecordOpenOptionsEnum	Specifies options for opening a Record. These values may be combined by using an OR operator.
RecordStatusEnum	Specifies the status of a record with regard to batch updates and other bulk operations.
RecordTypeEnum	Specifies the type of Record object.
ResyncEnum	Specifies whether underlying values are overwritten by a call to Resync.
SaveOptionsEnum	Specifies whether a file should be created or overwritten when saving from a Stream object. The values can be combined with an AND operator.
SchemaEnum	Specifies the type of schema Recordset that the OpenSchema method retrieves. Specifies the direction of a record search within a Recordset.
SearchDirectionEnum	Specifies the direction of a record search within a Recordset.Specifies the type of Seek to execute.
SeekEnum	Specifies the type of Seek to execute.Specifies options for opening a Stream object. The values can be combined with an AND operator.
StreamOpenOptionsEnum	Specifies options for opening a Stream object. The values can be combined with an AND operator.Specifies whether the whole stream or the next line should be read from a Stream object.
StreamReadEnum	Specifies whether the whole stream or the next line should be read from a Stream object.Specifies the type of data stored in a Stream object.
StreamTypeEnum	Specifies the type of data stored in a Stream object.Specifies whether a line separator is appended to the string written to a Stream object.
StreamWriteEnum	Specifies whether a line separator is appended to the string written to a Stream object.Specifies the format when retrieving a Recordset as a string.
StringFormatEnum	Specifies the format when retrieving a Recordset as a string.Specifies the transaction attributes of a Connection object.
XactAttributeEnum	Specifies the transaction attributes of a Connection object.