B
Beverly76
I had about 20 tables linked directly to Excel, but that slowed my database
down significantly. I created an intermediate database with the links in
place and then queries to make tables out of the links and export them to my
main database. This successfully sped up the main database reports.
Now, I am trying to automate the process of updating the data. I have a
macro in my stored database (Datafiles.mdb) which runs the queries that
update the tables in (Project.mdb).
How do I tell Access to get to that macro, or alternatively tell Access to
run those queries in (Datafiles.mdb) ultimately from my switchboard in
Project.mdb?
down significantly. I created an intermediate database with the links in
place and then queries to make tables out of the links and export them to my
main database. This successfully sped up the main database reports.
Now, I am trying to automate the process of updating the data. I have a
macro in my stored database (Datafiles.mdb) which runs the queries that
update the tables in (Project.mdb).
How do I tell Access to get to that macro, or alternatively tell Access to
run those queries in (Datafiles.mdb) ultimately from my switchboard in
Project.mdb?