Error Msg: Can't open anymore databases

[Guest]

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?

 

[IT_Roofer]

on Wed 25 Jul
2007 08:50:02a:

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?

Nevermind. I just moved my db statements into an if clause and now it's
fine.