Please help! do I need to synchronize mysql to Access database. preferably via xml. I managed to get mysql database structure: Table name="data"> <Field name="id" type="int(11)" null="NO" key="PRI" default="" autoincrement="false"/> <Field name="data" type="varchar(255)" null="NO" key="" default="" autoincrement="false"/> <Field name="data2" type="varchar(255)" null="NO" key="" default="" autoincrement="false"/> </Table> I do not know how to write the database access.When I need to add a column in MySQL to create and access databases, without losing the original data.I also needed to synchronize data that has changed. many thanks for your help