Can you do something like this:<BR><BR>If rsUsers.Open Then rsUsers.Close<BR><BR>If not how can you check to see if the recordset is still open?
wouldn't you know if you'd closed it?<BR><BR>Anyway you can use the state property:<BR><BR>http://www.devguru.com/Technologies/ado/quickref/recordset_state.html<BR><BR>
because sometimes i forget to close the connection at the end of my scripts and i've seen it hang a thread in the server before and really screw up IIS. so I just wanted to ensure i closed all connections. Thanks for the info.<BR><BR>AJ<BR>