Running VB module from other application

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?
 
M

Marshall Barton

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).
 

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

Create A Database with VB Code 1
Calling Access 'form' from other applications 0
Create a database using VB Code 1
Using code to edit modules 6
Run a Module from an event proceedure 2
Record insert/delete anomaly 0
Function Modules vs Sub Modules 4
Usin VB in Sql Server 7

Top