Detect another open .mdb

  • Thread starter Thread starter Milo
  • Start date Start date
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?
 
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.
 
My help does not work very well... please post the
statement on how to open another .mde
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

detect password protected mdb's 3
Access 2003 and/or 2007 copy in objects from another mdb 1
How to open in EDIT a MDB application 2
Opencurrentdatabase (without open a new database) 0
How to detect an .ade database programatically - Access 2003 1
Change reference databases with VBA 2
Can I distribute an MS Access mdb for interaction from MS Word VBA 3
Opening another Access db with variable name from same folder 4

Back
Top