How do I check if a database is open

[Denster]

Need to put a check in the coding, to see if the database is open. then put an "if not" open it statement in.

Thanks

Denster

 

[Schroeder]

If it's an Access db, I check for the existence of the dbName.ldb file in the same directory.

 

[zemp]

What do you mean by open? The program already has an open connection to it, or the database is opened by its program (like Access).

If it is the former, what tools are you using? If you are using ADO then check the connection state.

If CONN.State = adStateOpen then
   'connection is open
Else
   'Not open
End If

zemp