Unanswered: linked update of access database to mysql database
i am trying to send table data from access database to mysql database and the data sending should be automated. I never worked with access database or VB. I searched google but did not find a proper solution for this. Does anyone worked with the similar problem or have any suggestions?
I installed ODBC driver, Created DSN. But there is a problem in the Access 2007. In the External Data source there are two options with ODBC function, Export and Import. In Import there is a option for creating a link table but in Export there is no option for creating any link table. When i create a link from the Import function it is only updating the data from Mysql to Access. Changes made in the access database doesn't change the mysql database!!!