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 Values
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 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.