Clay,

Try:

If VacConn.State = adStateOpen Then VacConn.Close


--
Hope that helps.

Vergel Adriano


"Clayman" wrote:

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...
--
Adios,
Clay Harryman