how do I tell if a recordset is open

Is there any way to determine if an ADO recordset is open, without resorting to error codes?
TIA.
schoonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jcmldConnect With a Mentor Commented:
Is with the state propierty:
 suppose r is a recordset

 If r.state=adstateopen then
   msgbox "The recordset is open"
 else
  msgbox "The recordset is closed"
 end if

Or

 If r.state=adstateclosed then
   msgbox "The recordset is closed"
 else
  msgbox "The recordset is open"
 end if
 
0
 
northeykCommented:
Check the .State of the recordset.

If rs.State = adStateOpen Then
   ...
End If

Other constants:
  adStateClosed
  adStateConnecting
  adStateExecuting
  adStateFetching

Note: The Recordset object’s .State property can have a combination of
these values.

For example, if a statement is executing, this property will have a combined value of adStateOpen and adStateExecuting.

0
 
schoonAuthor Commented:
Thanks! Works great.

(Sorry northeyk but jcmld beat you by one minute and I don't know how to split the points.)
0
All Courses

From novice to tech pro — start learning today.