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.
 
Back
Top