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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top