Auto report from DBs in 3 different sites

  • Thread starter Thread starter AGOKP4
  • Start date Start date
A

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!
 
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.
 
Thanks for your reply. In order to create this linkage, do I need to update
each time I receive new data?
 
You shouldn't have to relink unless the MDB files or tables change names or
locations.
 
Back
Top