auto table update of mysql database from access database

[ridwan]

Is there any way the table data in Mysql will be automatically updated from the Access database after exporting the first time?
My Access table is updated every hour. How can i synchronize the transfer of data between the two database?

[Rabbit]

Link the table instead of importing it into access. That way, any changes on the Access side will immediately reflect on the mysql side.

[ridwan]

How Do i do that? i linked the table with mysql database but nothing happening when i change the access database. but after creating the link the access database is changing when i change the mysql database.

[Rabbit]

You created a link to the access database from mysql? You need to do it the other way around.

[ridwan]

Yes. But i never worked with the access database before.I created the link to the access database using the link that appears in the import option in the Access database. How can i create a link to the mysql from access database?

[Rabbit]

That depends on what version of Access you're using.

[ridwan]

I am using access 2007

[Rabbit]

It's under External Data > Import > More > ODBC Database

[ridwan]

But that updates the access database from the Mysql database. How do i do the opposite?

[Rabbit]

The link should go both ways.

[ridwan]

I created the link but it only updates the data from mysql.if i update the Access database nothing happens in the mysql database. :(

[Rabbit]

Check the advanced options on the DSN. Perhaps there's something set incorrectly there.

[ridwan]

I went through the settings.If you can suggest me about the settings to change it would be easier for me. I have no idea about what to change. I never worked with access database before.

[Rabbit]

I don't know which setting it would be, I've never had to change them to get them to work. Look for something along the lines of read only.

[ridwan]

Thank you.It worked.I had to remove the real table and rename the linked table to its original table name.