Remote Connectivity in MS ACCESS

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

 

[Granny Spitz via AccessMonster.com]

I want to click a button on this form and run a macro
from database A.mdb. How do I do it ?

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"