State - property of the AdoRecordset object
Detects whether the AdoRecordset
object is open, closed, connecting, executing or retrieving data.
0 - (adStateClosed) Object is closed.
1 - (adStateOpen) Object is open.
2 - (adStateConnecting) Object is connecting.
4 - (adStateExecuting) Object is executing a statement.
8 - (adStateFetching) The records of the object are being retrieved.
Property access for read only.
var nState = oRs.State;