Inter-database commands

  • Thread starter Thread starter dean.brunne
  • Start date Start date
D

dean.brunne

I have split my processes into two databases: database 1 and database
2. The Main Menu is in database 1. I want to have a butoon on the
Main Menu which will run a macro stored in database 2 to run on data
in database 2. How do I use code to run that macro. I have tried

Dim db as Database

Set db = "c:\database1.mdb"

DoCmd.RunMacro "Macro1"

This does not work.

Please advise
 
Hi Dean,

Firstly, macros are horrible and best avoided... HOWEVER... to do what you
are after, could you simply not import the macro into your front end and let
it run on the linked tables?

Damian.
 

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

Macro question?? 4
Copy data from one databse tabel to other database table 1
Opening another Access DB from a Form Button 4
Create A Database with VB Code 1
Access how to open existing database from another database using Access - VBA 0
Access Command to run access, open to specific form and specific record 1
Run macro in an external access db from current access db 1
Access Select From External Access Database with path entered as Input parameter in query 0

Back
Top