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.