SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Zealot jadmadi's Avatar
    Join Date
    Sep 2003
    Location
    Jordan
    Posts
    154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    auto update access to mysql

    Hi,
    I am working on project which needs a connection between access database and mysql,
    my customer has access database of his products on his machine, he want whenever he update his access DB the mysql database on his website to be auto updated,
    How can i do that without repeating the records, and what is the best way to perform the update


    Thank you in advance.

  2. #2
    SitePoint Zealot jadmadi's Avatar
    Join Date
    Sep 2003
    Location
    Jordan
    Posts
    154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    anyone?

  3. #3
    SitePoint Zealot
    Join Date
    Jul 2002
    Posts
    173
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I could be wrong, but I am almost sure I ran across an .mdb to mysql 'convertor' somewhere months ago...or saw a post about it.

    Have you checked the MySQL website?

    If such a thing exists, all he would have to do is run the .mdb through the convertor and INSERT the data into the MySQL table.

    Good luck!

  4. #4
    SitePoint Zealot
    Join Date
    Jul 2002
    Posts
    173
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was right:

    Access-to-MySQL

    (Converters / Using MySQL with other products)

    Access-to-MySQL is a program to move MS Access databases to MySQL server.
    Depending on your privileges on the target MySQL server, you can either
    export MS Access data into new database, or overwrite the contents of an existing MySQL database.

    (FROM http://www.mysql.com/portal/software/item-98.html


  5. #5
    SitePoint Zealot jadmadi's Avatar
    Join Date
    Sep 2003
    Location
    Jordan
    Posts
    154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you
    i'll check if this handy-tool do the trick

    However, I want to keep using both of MySQL and MS access.
    MySQL for web.
    MS access for my customer machine.

    and update the web database with the latest enteries from MS access database.

  6. #6
    SitePoint Zealot
    Join Date
    Jul 2002
    Posts
    173
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey...

    I just noticed you are in Jordan.

    FYI, I had an opportunity about, umh, 15 years ago to visit Jordan with some "Amateur Radio" operator friends. The got to stay in the King's Palace...and operated in a big WorldWide Radio contest.

    I've been kicking myself for years now that I did not go on the trip

    The King (who was also a "Ham" Radio operator), then flew all the group down to visit the Dead Sea in one of his airplanes.

    My friend called me upon their return and said: "You missed the trip of a lifetime!!!"

    Oh well

  7. #7
    SitePoint Zealot jadmadi's Avatar
    Join Date
    Sep 2003
    Location
    Jordan
    Posts
    154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    "You missed the trip of a lifetime!!!" AGREED!!!

    But wait, you still breathing, You are welcome at anytime to visit us

  8. #8
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have a look at using linked tables between Access and MySQL via the MyODBC driver...
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  9. #9
    SitePoint Zealot jadmadi's Avatar
    Join Date
    Sep 2003
    Location
    Jordan
    Posts
    154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you Hillsy.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •