Optimal database deployment

B

bjnova

I am using Access to collect data from a web form. Copies of this web form
exist in two different places folders on server A, and so far as I can tell,
the database needs to be in each of those folders. I would like, however,
for a user to be able to access all the records from a single repository and
was thinking to write the contents of the two databases to one single set of
tables on server B; is this reasonable? Is it doable in an automated fashion
or only manually by manually running append and other queries?
 
A

Andi Mayer

I am using Access to collect data from a web form. Copies of this web form
exist in two different places folders on server A, and so far as I can tell,
the database needs to be in each of those folders. I would like, however,
for a user to be able to access all the records from a single repository and
was thinking to write the contents of the two databases to one single set of
tables on server B; is this reasonable? Is it doable in an automated fashion
or only manually by manually running append and other queries?

why not link this tables and use a Union query?
 
Top