Using a macro to run queries in different dbs

[Myriad_Rocker]

Okay, here's the deal. We have several Access databases that serve several different purposes. There are tables in those databases that are linked to a DB2 database. I want to be able to run one macro in my personal Access database that will go out and run all these different queries to udate tables in various databases.....

Possible or no?



I have an idea about something different I can do. That is, make an Access database with all my linked tables from DB2 and have a macro that copies all the records to tables in Access and then link to those tables from the other databases...is this more realistic?