Auto update of Access DB from 3 other Access Databases

[AGOKP4]

hello all,

I created a DB with the assistance of members of this site (many thanks!)
that we use in 3 different centers (same DB), the study ID is the defining
factor for the data. I currently import the updated tables I get from each
site to generate summary reports

Is it possible to this this programmatically? Run a query to run this
instead of doing it manually? I tried linking the DBs once but it began to
run so slow that i had to continue importing the data manually.

thanks!!!

 

[Piet Linden]

hello all,

I created a DB with the assistance of members of this site (many thanks!)
that we use in 3 different centers (same DB), the study ID is the defining
factor for the data.  I currently import the updated tables I get from each
site to generate summary reports

Is it possible to this this programmatically?  Run a query to run this
instead of doing it manually?  I tried linking the DBs once but it began to
run so slow that i had to continue importing the data manually.

thanks!!!

LOL... this sounds like my old job!!!

If you create links to the 3 databases, then you can either create a
union query to summarize the data or import the data into a new
database with a cloned structure. You could do tis really easily
after some initial work... You could create links to all the tables
in one database that you need to import from. Then in your code, you
could do the following:

1, set the link to point at the correct database (you could put this
in a table - makes it simple to choose databases to point to).
2. run a series of append queries, (base it on a Find Unmatched Query
wizard result). One for each table you need to import.
3. once these work, create a startup form, and in the Open event of
the startup form, call the function that runs the imports. (And it
must be a Function and not a Sub...)

Allen Browne has a great example on his website. www.allenbrowne.com
I think it's under the Programmer section...