Remote Connectivity in MS ACCESS

  • Thread starter Thread starter amey.gupte
  • Start date Start date
A

amey.gupte

Hi,
I have 2 MDB files (databases) in one folder - say A.mdb and B.mdb.
Database A.mdb has my tables and queries and macros. The forms are in
database B.mdb. I want to click a button on this form and run a macro
from database A.mdb. How do I do it ?

Thanks & Regards,
Amey Gupte
MS in Management Information Systems
Mays Business School
Texas A&M University.
 
I want to click a button on this form and run a macro
from database A.mdb. How do I do it ?
Click to expand...

Link to the tables in A.mdb (back end) from B.mdb (front end), giving these
linked table names the same names as the originals. Import the queries and
macros from A.mdb to B.mdb. In your button's click event paste this:

DoCmd.RunMacro "MacroName"
 
Back
Top