Synchronization Between MS Access and MySQL

MS Access to MySQL converter implements synchronization as combination of insert records from source table missing in the destination table and update existing MySQL records with MS Access data. For synchronization purpose source and destination tables must have identical structures and have primary key or unique index defined.

Assume both MS Access and MySQL databases have table "People" defined as below:

    Table1(
        ID Integer NOT NULL, 
        FName Varchar(50),
        LName Varchar(50), 
        EMail Varchar(50), 
        Primary Key (ID)
    );

This table has the following contents in MS Access database:

In MySQL database:

After migrating MS Access data to MySQL in "Synchronize" mode the source table is kept untouched and the destination table is modified as follows (pay attention to the cell marked red):