50 different databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHIPP - 29 Oct 2004 16:17 GMT

I have a master database of employees. What I need to do is to automate the
creation of 50 different databases with only the data for each of those 50
individual managers contained in their private database. They will then fill
out employee reviews. After that they will return their private database back
to me. I then need to automate the merging of that data back into my master
database. Any ideas on the easiest way to approach this would be most
appreciated.

Signature

M. Shipp

Reply to this Message

Paul - 29 Oct 2004 23:45 GMT

Partial replication may be useful in this scenario. See Access help for
replication.

Signature

Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org

>I have a master database of employees. What I need to do is to automate the
> creation of 50 different databases with only the data for each of those 50
[quoted text clipped - 6 lines]
> database. Any ideas on the easiest way to approach this would be most
> appreciated.

Reply to this Message