Edit

State Property (ADO)

  • Article

Indicates for all applicable objects whether the state of the object is open or closed. If the object is executing an asynchronous method, indicates whether the current state of the object is connecting, executing, or retrieving.

Return Value

Returns a Long value that can be an ObjectStateEnum value. The default value is adStateClosed.

Remarks

You can use the State property to determine the current state of a given object at any time.

The object's State property can have a combination of values. For example, if a statement is executing, this property will have a combined value of adStateOpen and adStateExecuting.

The State property is read-only.

Applies To

Command Object (ADO)
Connection Object (ADO)

Record Object (ADO)
Recordset Object (ADO)

Stream Object (ADO)

See Also

ConnectionString, ConnectionTimeout, and State Properties Example (VB)
ConnectionString, ConnectionTimeout, and State Properties Example (VC++)