Detect another open .mdb

M

Milo

I want to know if another database (.mdb) is running. If
not, I want to start it from Access-VBA.

How do I detect whether it is running or not?
How do I start another .mdb from VBA?
 
M

Mart

Milo said:
I want to know if another database (.mdb) is running. If
not, I want to start it from Access-VBA.

How do I detect whether it is running or not?
How do I start another .mdb from VBA?
Click to expand...

If you have a look in VBA help at 'Workspace' there is an exapmle there
which creates a new db and then loops through all open dbs.... so just modify
this one and it should do it.

Mart.
 
M

Milo

My help does not work very well... please post the
statement on how to open another .mde
 
Top