State Property (ADO)

   Example   Applies To   

Describes for all applicable objects whether the state of the object is open or closed.

Describes for a Recordset object executing an asynchronous method, whether the current state of the object is connecting, executing, or fetching.

Return Value

Returns a Long value that can be one of the following constants.

Constant Description
adStateClosed Default. Indicates that the object is closed.
adStateOpen Indicates that the object is open.
adStateConnecting Indicates that the Recordset object is connecting.
adStateExecuting Indicates that the Recordset object is executing a command.
adStateFetching Indicates that the rows of the Recordset object are being fetched.

Remarks

You can use the State property to determine the current state of a given object at any time. This property is read-only.

The Recordset 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.