| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if ADO connection open
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if ADO connection open
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if ADO connection open
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check for Internet connection | Excel Programming | |||
| How to check for an open network connection? | Excel Programming | |||
| How to check for an open Network connection in Excel VBA? | Excel Programming | |||
| Check for valid SQL server connection | Excel Programming | |||
| Open a connection to dbf file | Excel Programming | |||
Hybrid Mode
