ADO .open on an already open table 1

[ericksoda]

I am converting an application from DAO to ADO. One of the problems I am finding is that in DAO, I could open a recordset multiple times without closing it. In ADO, I cannot be so sloppy because it gives me an error about not opening an already open object.

How do I check if a recordset is already open?

If rs.open = true would be nice, but doesn't work. Is there something like that? I have looked through the documentation and didn't see this one.

Thanks for your help!

David

 

[vbajock]

http://www.devguru.com/Technologies/ado/quickref/recordset_state.html

 

[ericksoda]

Thanks! I had already coded my app to correctly close the object, but there are times when this will be needed.

David