Auto report from DBs in 3 different sites

[AGOKP4]

Hi,

I'm not sure if this is the right section to post this question, so pls bear
with me. I want to find out if its possible to AUTOMATE updates to a DB
report from data we receive from outside sites.

I created 3 DBs used in 3 different sites, they all have the same forms, the
only difference is the study ID#s. These sites send me the DB with weekly
updates, I would like to automate these updates for our reports instead of
importing manually, is this possible? Pls let me know

THANKS!

 

[Duane Hookom]

It isn't clear what you want to do with the 3 different databases or the
reports. You can link to tables in all three MDBs from another MDB. You can
create reports from the linked tables.

 

[AGOKP4]

Thanks for your reply. In order to create this linkage, do I need to update
each time I receive new data?

 

[Duane Hookom]

You shouldn't have to relink unless the MDB files or tables change names or
locations.