Merging Databases in MS Access 2000

The answer is "It Depends"!

If you have a simple database with only one table then a straightforward append query will do the trick.

If you have user configurable look-up tables or inter table relationships that use autonumbers then there is a bit more to it.

I found an excellent article "How to Merge Records from Two Identical Access Databases" at http://www.databasejournal.com/features/msaccess/article.php/2236471

It looks a bit complicated but if you take backup copies first and take it one step at a time it should work.

If you get stuck post back here with details.

I guess networking is excluded ? If yes, than the only choice is creating a macro that deletes the existing table and creates a new one by appending the 4, one by one using one create table query and 3 append queries. Or, if the macro only deletes data from the table (using a delete query with no criteria), you use 4 append queries to recreate it with the new data coming from the 4 PC's.