Running VB module from other application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I want to run a module/function that is located in one access data base from another access database. For example there is a function that update tables in database "X". I want to be able to add a macro/VB code in database "Y" that will run a fuction on database "X" so the data in database "X" will be updated. How can i call a function on another DB?
 
energy said:
Hi, I want to run a module/function that is located in one access data base from another access database. For example there is a function that update tables in database "X". I want to be able to add a macro/VB code in database "Y" that will run a fuction on database "X" so the data in database "X" will be updated. How can i call a function on another DB?
Click to expand...


You have two options here. One is to use Automation: open a
second instance of Access with the other db.

The other is to reference the other mdb file as a library so
you can call its public procedures (in standard modules).
 
Back
Top