473,320 Members | 2,189 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 10172
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 ?
Sep 28 '21 #20

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

Similar topics

0
by: jack daniels via .NET 247 | last post by:
Hi! Perhaps you know of a better way here. I have an Access database, actually a single table. Now, at the click of a button on a C# Form, each and every single cell associated with the primary...
0
by: Tim | last post by:
I need to link my access database to autoroute. I have inserted a button that will open autoroute on one of the forms within my DB but i would ideally like to have the application open up to a...
1
by: authorking | last post by:
Now I have create a database with ADOX component, could I create a table and read or modify the data in the databse with OLEDB component ?
1
by: taleran58 | last post by:
Hi all. I'm writting a multithreading program that will update a loacal Access database. I'm using OleDB connection to get access to the database from each thread and my question is: how do I...
5
by: Mark | last post by:
Hi - I've a data table that I want to save to an external Access database. I'm interested in sample code that would perform this save. Thanks, Mark (VB.NET, .Net framework 1.0)
1
by: stephen.anderson | last post by:
Can anyone point me to an existing utility or code template to write a utility? I want a command line utility, passing in the MDB filename, producing a file (text or whatever) of tablenames and...
1
by: soniasherry | last post by:
Can I please get some guidance.I'm new to MSACCESS 2003 How do I update all the tables in a main access database file with around 50 tables with unique records from similar tables placed in...
1
by: Viperoptic | last post by:
Hi All I am doing an update query from MS Access on a few records. The update work once perfectly but a soon as I run it again it returns the error below... "I have 5 records that won't do...
5
by: Yew12 | last post by:
I have been trying to update the details in a access database but, all I get is a white screen and all the errors I have built-in give me no help at all. All help is greatly appreciated. ...
2
by: susinthaa | last post by:
Hi, we are having some text values in the variable of the VB form and we have to insert these datas into the MS Access database. We have opened the database and only one record is inserted in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.