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.