Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I *thought* my code was closing the connections when it was done, but
apparently it isn't. I can't figure out why, but I was wondering if there was a way to detect the connection state to a database... I usually use something like this to set my database variable: Dim db As Database With that, I was thinking there would be a way to drop in a line like: If db.Connection = True Then db.Close Am I on the right track? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 won't open anymore | Excel Discussion (Misc queries) | |||
Import Access Data from 3 databases into 1 worksheet *ERROR* | Excel Discussion (Misc queries) | |||
EXCEL:Can't open any file without error saying it's ALREADY open??? | Excel Worksheet Functions | |||
databases | Excel Worksheet Functions | |||
Databases | Excel Discussion (Misc queries) |