U can use the state property of the recordset and connection object

if dbConnection.state=adstateopen then
' place here the code to use existing connection
else
' place here the codes for opening a connection
endif

there are the possible values for State property

adStateOpen
adStateClose
adStateConnecting
adStateExecuting
adStateFetching

Brgds Manish