SitePoint Sponsor

User Tag List

Results 1 to 10 of 10

Thread: help fast!

  1. #1
    Bah, I'll just hack it DoobyWho's Avatar
    Join Date
    Jul 2002
    Posts
    476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help fast!

    Okay, i've got an access database that i got from someone. They want to be able to update their access database and in turn, have it update their mysql database. How would i set up the database so that it sends the records from the Access database into the correct fields on the MySql database? I know it has something to do with setting up a ODBC connection. But i dont know anything more then that.

  2. #2

  3. #3
    Bah, I'll just hack it DoobyWho's Avatar
    Join Date
    Jul 2002
    Posts
    476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks.But those are programs. There is a way to do it with only Access/MyODBC and MySql.

  4. #4
    SitePoint Guru enygmadae's Avatar
    Join Date
    Sep 2002
    Location
    Dallas, Tx.
    Posts
    795
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    PHP News, Views and Community: http://www.phpdeveloper.org

  5. #5
    ǖber abstrakt's Avatar
    Join Date
    Dec 2001
    Location
    Earth
    Posts
    261
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Here, try this tutorial then.

    Here's a quote from it:
    "In this article, I’ll demonstrate just how easy it is to install and configure MyODBC and subsequently use Microsoft Access to manage MySQL data."

    http://www.devshed.com/Server_Side/M...DBC/page1.html
    Last edited by abstrakt; Sep 27, 2002 at 12:12.

  6. #6
    ǖber abstrakt's Avatar
    Join Date
    Dec 2001
    Location
    Earth
    Posts
    261
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The codewalker tutorial is going from MySQL to Access, he wants to go from Access to MySQL and maintain the data structure.

    I'd like to see him get this figured out, maybe he can go backwards on the codewalker tutorial ?

  7. #7
    SitePoint Guru enygmadae's Avatar
    Join Date
    Sep 2002
    Location
    Dallas, Tx.
    Posts
    795
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah, that's what I was figuring....*shrug* always good to have more than enough information than not enough.
    PHP News, Views and Community: http://www.phpdeveloper.org

  8. #8
    ǖber abstrakt's Avatar
    Join Date
    Dec 2001
    Location
    Earth
    Posts
    261
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by enygmadae
    yeah, that's what I was figuring....*shrug* always good to have more than enough information than not enough.
    Roger that, I 100% agree.

  9. #9
    Bah, I'll just hack it DoobyWho's Avatar
    Join Date
    Jul 2002
    Posts
    476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks! that helped alot!

  10. #10
    ǖber abstrakt's Avatar
    Join Date
    Dec 2001
    Location
    Earth
    Posts
    261
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    which one ?


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
  •