mysql table to Access database
-
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
-
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
What do you mean "write the database access?"
The difficult we do right away... ...the impossible takes slightly longer.
-
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
MS Access does not read XML. You can create a MYSQL connection in ODBC, and you can link MS Access to any ODBC data source i.e. use linked tables. Linked tables don't store data so if you make a change in the data in Access, you would be changing data in MYSQL and vice-versa.
-
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
You could write an API as an application to sit in front of MySQL and then a macro or application to sit in front of the Access database to consume the XML, but it would be... interesting, not to mention the deadlocks you would probably get would be a nightmare to sort out.
