Hi all....I will just like to say thanx in advance for reviewing my msg....well guy i'm kindda in a jam right now....well as u all can see from the image 2 file I uploaded with msg, I got 2 indentical db which is db1 and db2 with the same table sturcture (indentical)....

The problem is would to merge the 2 table in the diference db into 1 table so my data in either one of the db is update....so can anybody help me with please...please would somebody help me with this issue..

If I understand it correctly, you must just link one table from one database to the actual one and then perform an append-query where you append all fields form one table to the other table.

flofi