What will you do if two colleagues modify the same record?

Your table needs to have a timestamp column which is updated whenever the
record is updated. Then when your colleagues ship you the table, you need to
replace any record where the timestamp is later than the current one. Sounds
like you might also need an 'UpdatedBy' column, yso you can track who last
changed a record.

This all sounds like a weird arrangement. Are you sure there is not a better
way, like making the db multi-user and just have everyone access it.

-Dorian

You can create an update query to do this.
Open the query builder.
Add your main table.
Add the other table. (do this one other table at a time)
Create a join between the two tables.  Select 2 as the Join Type.
In the first row, enter the name of all fields in your main table.  If your
tables have an autonumber field, do not include that field.
In the Update To row, enter the name of each field in the other table below
the same field name of the main table.

When you run the query, it will update the field values in the main table
from other table.