State Property (ADO)

The State property returns a value that describes if the object is open, closed, connecting, executing or retrieving data. The value returns an ObjectStateEnum value. Default is adStateClosed.

This property applies to:
Command, Connection, Record, Recordset, and Stream objects.

The State property can have a combination of values. If a statement is executing, this property will have a combined value of adStateOpen and adStateExecuting.

Syntax

object.State

Example

For a Command object:

Dim conn As ADODB.Connection
Dim comm As ADODB.Command

Set conn=New ADODB.Connection
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "Data Source=F:\MaterialMaster\Material_Master.mdb"

Set comm=New ADODB.Command
Debug.Print (comm.State)

conn.Close

For a Connection object:

Set conn=New ADODB.Connection
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "Data Source=F:\MaterialMaster\Material_Master.mdb"

Debug.Print (conn.State)
conn.Close

ObjectStateEnum Values

Specifies whether an object is open or closed, connecting to a data source, executing a command, or retrieving data.

Constant	Value	Description
adStateClosed	0	The object is closed
adStateOpen	1	The object is open
adStateConnecting	2	The object is connecting
adStateExecuting	4	The object is executing a command
adStateFetching	8	The rows of the object are being retrieved