#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    2
    Rep Power
    0
    Has anybody an idea how to synchronize an MS Access-table with a MySQL-table. Replication?

    daniel
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Netherlands
    Posts
    77
    Rep Power
    15
    You can use ODBC linked tables in Access through MyODBC.
    You can find MyODBC in the download section of http://www.mysql.com

    Peter
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    2
    Rep Power
    0
    Thanks PAV for your help. I already use MyODBC to edit MySQL tables with MS Access. But thats not what I mean by replication or synchronization. I want to have a local copy of an MySQL table which I can edit offline. From time to time I want to go online and synchronize this two tables. That means:
    1) New or updatet local entries should be copied to the MySQL table, 2) New or updatet entries in the MySQL talbe should be copied to the local table 3) If an entrie is updatet in both tables, Access should ask me which one is the right one. This is possible with an MS SQL-Server. But is it also possible with MySQL?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Netherlands
    Posts
    77
    Rep Power
    15
    OK, I understand.
    As far as I know there is no such function in MySQL.
    I think you don't get around to do some programming in MS Access. In this you check for changes in the local MySQL db and in the MySQL db on the server, move these changes from both db's to an temp db and update both db's again with these changes.
    But what if a record is changed both on the local and server side, which one do you take, I wonder?

    Peter

Similar Threads

  1. mysql -> odbc --> ms access -> vb
    By himurakenshin in forum MySQL Help
    Replies: 2
    Last Post: December 28th, 2003, 09:32 PM
  2. access - mySQL interaction question
    By alexmasters in forum PHP Development
    Replies: 0
    Last Post: December 5th, 2003, 11:31 AM
  3. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 04:16 AM
  4. Replies: 3
    Last Post: September 29th, 2002, 06:48 PM
  5. Run Access query in MySQL
    By yigalm in forum MySQL Help
    Replies: 3
    Last Post: August 30th, 2001, 06:56 PM

IMN logo majestic logo threadwatch logo seochat tools logo