Is the Connection closed???

Question???

How do I check to see if 1 or the other connection to a database are closed or not?

Dim cnnDVD As New ADODB.Connection
Dim rstDVD As New ADODB.Recordset
Dim rstDVDCheck As New ADODB.Recordset Dim strSQLDVD As String Dim cnnVHS As New ADODB.Connection
Dim rstVHS As New ADODB.Recordset
Dim rstVHSCheck As New ADODB.Recordset
Dim strSQLVHS As String


These are my connections and recordsets, recordset checks, and SQL strings, if that helps any.

Thanks to anyone who answers.

I'm not sure why you are using the old ADODB objects but either want the ADO and ADO.NET connection objects have a State property that will tell you if they are open or closed or what not.

Thanks.
I figured it out right before you replyed.