Syncronizing Table

[naungsai]

Is it possible to to syncronize table from 2 files?

 

[Rabbie]

Can you give a little more detail about what you are trying to achieve. Synchronisation in Access usually refers to keeping multiple copies of a DB consistent.

 

[naungsai]

I mean merge the similar tables of 2 files.

 

[Rabbie]

If you mean merging the data from two similar DBs you need to consider the following points

Are you using Autonumber fields. If so you will need to ensure you don't have duplicates between the two versions of each table. You also need to check that any relationships will not be broken if you change the linking IDs

Once you have resolved these issues then you can use an Append query to move the data from one table to another. Or possibly use a Union query. See access help for more info

 

[naungsai]

Thanks for quick reply.
I have try it with Append query. It works.

Best

 

[Rabbie]

Happy to have been of help. Glad to hear you have got it working