How do feed data from one Access database into another?

[Sallie Leo]

Problem: I have six people, each on their own system who all need to enter
data into an Access table that then needs to feed into one primary database.
Do I create a separate database for each user, save them all to a shared
drive, create a "master database" and save it to the same shared drive and
then link the six individual DB's to the "Master" or am I completely on the
wrong track?
I need the simplest solution possible because the folks who will be entering
the data have no Access training at all HELP!!!

 

[Douglas J. Steele]

The application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables).

Only the back-end should be on the server. Each user should have his/her own
copy of the front end on their hard drive. That way, each will be updating
the same table, but will be working independently of the others.

See what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm for more details.

 

[bbttyy]

Problem: I have six people, each on their own system who all need to enter
data into an Access table that then needs to feed into one primary database.
Do I create a separate database for each user, save them all to a shared
drive, create a "master database" and save it to the same shared drive and
then link the six individual DB's to the "Master" or am I completely on the
wrong track?
I need the simplest solution possible because the folks who will be entering
the data have no Access training at all HELP!!!

 

[Jerry]

-----Original Message-----
Problem: I have six people, each on their own system who all need to enter
data into an Access table that then needs to feed into one primary database.
Do I create a separate database for each user, save them all to a shared
drive, create a "master database" and save it to the same shared drive and
then link the six individual DB's to the "Master" or am I completely on the
wrong track?
I need the simplest solution possible because the folks who will be entering
the data have no Access training at all HELP!!!
.

You need to have two mdb's. One with the data, on a
shared drive, and the other with the forms that have link
tables to the master mdb. Put this mdb on there local
drive (C). That's the only way - if you need help let me
know.