State Property - ADO

Describes the current state of an object.

Applies To

Command, Connection, Recordset

Return Values

Sets or 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.

Remarks

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

Examples

ConnectionString, ConnectionTimeout, and State Properties Example (VB)


© 1997 Microsoft Corporation. All rights reserved.