Combining Tables

[oystagoymp]

I have just started using MS Access to enter customers into a database. I constructed the database and delegated the .mdb file to my coworkers so that they can enter their customers as well. Now I would like to combine all the customers entered by all the employees into one general table/database containing all of the customers entered by all of the employees. If anyone knows how I would go about doing that I would really appreciate the knowledge. Thank you.

 

[Rickster57]

tables

I would have split the database. Put the back end on a server and the front end on each users computer. If in fact each user has their own set of data tables on a local drive you will have to apend those tables into to a master table.

 

[oystagoymp]

I am extremely, extremely new to Access. Could you please explain in a much simpler way as to what I must do? Thank you.

 

[Rickster57]

Split Database

If you want users to enter data that will be stored in one location (preferred method) split the database using the Database Splitter in Access. By doing this all the tables will be placed say on a server (let's call it the S: drive). As each user enters their data the table(s) will be populated with ALL the users data (called the Back end). The front end will contain forms, reports, qeuries etc. (front end). The front end mdb should be on each user's local drive.

This way the users will see all the data that has been entered by all users.
Search this forum for this topic as it has been documented several times.
Hope this helps.