C
consolidate multiple access databases
Greetings,
I created a database and currently each employee has a copy of it stored
locally on their computer where they're also entering data. The database
includes look-up columns and sub forms. They are now transitioning to the
use of a server and want one consolidated database. What is the most
efficient way to do this and purge any duplicate entries. I've seen posts
similar posts suggesting the replication function or append queries, however
I'm not sure which option is most fitting in this instance.
Thanks in advance for any feedback.
Kim, EBS
I created a database and currently each employee has a copy of it stored
locally on their computer where they're also entering data. The database
includes look-up columns and sub forms. They are now transitioning to the
use of a server and want one consolidated database. What is the most
efficient way to do this and purge any duplicate entries. I've seen posts
similar posts suggesting the replication function or append queries, however
I'm not sure which option is most fitting in this instance.
Thanks in advance for any feedback.
Kim, EBS