469,301 Members | 2,282 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,301 developers. It's quick & easy.

auto table update of mysql database from access database

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
19 9529
Rabbit
12,516 Expert Mod 8TB
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
ridwan
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
12,516 Expert Mod 8TB
You created a link to the access database from mysql? You need to do it the other way around.
May 17 '12 #4
ridwan
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
12,516 Expert Mod 8TB
That depends on what version of Access you're using.
May 17 '12 #6
ridwan
10
I am using access 2007
May 18 '12 #7
Rabbit
12,516 Expert Mod 8TB
It's under External Data > Import > More > ODBC Database
May 18 '12 #8
ridwan
10
But that updates the access database from the Mysql database. How do i do the opposite?
May 19 '12 #9
Rabbit
12,516 Expert Mod 8TB
The link should go both ways.
May 19 '12 #10
ridwan
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
12,516 Expert Mod 8TB
Check the advanced options on the DSN. Perhaps there's something set incorrectly there.
May 20 '12 #12
ridwan
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
12,516 Expert Mod 8TB
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
ridwan
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
ridwan
10
Is it possible to update the main table when the link table is updated?
May 22 '12 #16
Rabbit
12,516 Expert Mod 8TB
What do you mean by main table?
May 22 '12 #17
ridwan
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
12,516 Expert Mod 8TB
This is the same thing we've been talking about. Reread the thread and see if any of it applies.
May 23 '12 #19
Check1123
1 Bit
Have you find any solution ?
3 Weeks Ago #20

Post your reply

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

Similar topics

reply views Thread by jack daniels via .NET 247 | last post: by
1 post views Thread by authorking | last post: by
1 post views Thread by taleran58 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.