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

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

Thank you! That did the trick.
--
Adios,
Clay Harryman


"Vergel Adriano" wrote:

> 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