Check if ADO connection open

[Guest]

Is there a way to check if an ADO connection is open in VBA? I'm currently
using:

If VacConn.Open Then VacConn.Close

assuming, wrongly of course, that the ADODB Connection Open method would
return a boolean...

 

[Guest]

Clay,

Try:

If VacConn.State = adStateOpen Then VacConn.Close

 

[Guest]

Thank you! That did the trick.