By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,599 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

auto table update of mysql database from access database

P: 10
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?
May 16 '12 #1
Share this Question
Share on Google+
18 Replies


Rabbit
Expert Mod 10K+
P: 12,315
Link the table instead of importing it into access. That way, any changes on the Access side will immediately reflect on the mysql side.
May 16 '12 #2

P: 10
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.
May 17 '12 #3

Rabbit
Expert Mod 10K+
P: 12,315
You created a link to the access database from mysql? You need to do it the other way around.
May 17 '12 #4

P: 10
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?
May 17 '12 #5

Rabbit
Expert Mod 10K+
P: 12,315
That depends on what version of Access you're using.
May 17 '12 #6

P: 10
I am using access 2007
May 18 '12 #7

Rabbit
Expert Mod 10K+
P: 12,315
It's under External Data > Import > More > ODBC Database
May 18 '12 #8

P: 10
But that updates the access database from the Mysql database. How do i do the opposite?
May 19 '12 #9

Rabbit
Expert Mod 10K+
P: 12,315
The link should go both ways.
May 19 '12 #10

P: 10
I created the link but it only updates the data from mysql.if i update the Access database nothing happens in the mysql database. :(
May 19 '12 #11

Rabbit
Expert Mod 10K+
P: 12,315
Check the advanced options on the DSN. Perhaps there's something set incorrectly there.
May 20 '12 #12

P: 10
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.
May 21 '12 #13

Rabbit
Expert Mod 10K+
P: 12,315
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.
May 21 '12 #14

P: 10
Thank you.It worked.I had to remove the real table and rename the linked table to its original table name.
May 21 '12 #15

P: 10
Is it possible to update the main table when the link table is updated?
May 22 '12 #16

Rabbit
Expert Mod 10K+
P: 12,315
What do you mean by main table?
May 22 '12 #17

P: 10
I mean as the access table is linked to the mysql table.When i change data in the local table of access database it does not reflect any change of data in the link table.what i want is when i add data to local table the link table should be updated and as the link table is updated, mysql table is updated.Is it possible to do that?
May 23 '12 #18

Rabbit
Expert Mod 10K+
P: 12,315
This is the same thing we've been talking about. Reread the thread and see if any of it applies.
May 23 '12 #19

Post your reply

Sign in to post your reply or Sign up for a free account.