UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Access to MySQL on different servers    
 
   
avincent
post Dec 18 2009, 04:19 PM
Post#1



Posts: 2
Joined: 18-December 09



I am trying to have my access database export a specific table to a database located on a different server.
He want to be able to send data from our access database to our web designers MySQL database, but here is the tricky part. We want our access database to be able to send this data to the other database (not housed on any of our servers) every 30 min or so to keep the designers data that they are using updated consistently.
Is there any solutions for this?
Go to the top of the page
 
BananaRepublic
post Dec 18 2009, 04:35 PM
Post#2


Dungeon Cleaner
Posts: 1,504
Joined: 16-June 07
From: Banana Republic


Why not simply create the table on MySQL and link to it? That would always keep the data up to date without any efforts toward synchronizing/replicating not to mention dealing with potentials bugs that could arise in DIY synchronizing.
Go to the top of the page
 
avincent
post Dec 18 2009, 04:58 PM
Post#3



Posts: 2
Joined: 18-December 09



That is a simple solution, but do you know of any tutorials or any help with that. Setting up the MySQL database is easy, but not sure how to create the macro to export to the other database every 30 min.
Go to the top of the page
 
dannyseager
post Dec 18 2009, 05:06 PM
Post#4


UtterAccess VIP
Posts: 13,031
Joined: 2-March 04
From: Leicester, UK


If you follow BananaRepublics suggestion then there is no syncronising every 30 minutes.
The suggestion was to create the table on the MYSQL server and create an ODBC connection on your PC's.
Then in access create a linked table and select the MySQL ODBC Connection.
Then select the table you created on the MySQL server.
By doing this it means that the MySQL database and your access database are using the same data... so it's always in sync.
Go to the top of the page
 
BananaRepublic
post Dec 18 2009, 05:19 PM
Post#5


Dungeon Cleaner
Posts: 1,504
Joined: 16-June 07
From: Banana Republic


No macros needed at all.
You would go to mysql.com and download the MySQL 5.1 ODBC Driver (here), install it on all computers where it needs access to MySQL server.
Then follow this instruction to link the tables. If needed, you may need to create a DSN.
Be aware about the recommended options to enable for the drivers. Particularly 'returning matching rows'. Timestamp are good thing but not necessary in all cases.
HTH.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 10:31 AM