s -or- Set recordset = connection.Execute (CommandText, RecordsAffected, Options) -or- recordset.Open Source, ActiveConnection, CursorType, LockType, Options -or- recordset.Requery Options
ObjectStateEnum
Constant
Value
Description
adStateClosed
0
Indicates that the object is closed.
adStateOpen
1
Indicates that the object is open.
adStateConnecting
2
Indicates that the object is connecting.
adStateExecuting
4
Indicates that the object is executing a command.
adStateFetching
8
Indicates that the rows of the object are being retrieved.
Specifies whether an object is open or closed, connecting to a data source, executing a command, or retrieving data. Read only.