Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    104

    Unanswered: Converting MDB to MySQL? Thoughts anyone

    Hi All,
    I was just wondering if...

    a.) It is a good idea to convert from a Microsoft Access 2000 Database to a MySQL database
    b.) It is POSSIBLE (if so, how?) to convert from MDB to MySQL?


    PS: one of the reasons I am asking this is that I am learning Apache/PHP/MySQL in college and we are using an MDB here at work. It would be nice to create a web interface using HTML/JavaScript/PHP to do all interaction with the database.

    Thanx beforehand for all the feedback / input
    Last edited by shassouneh; 04-14-04 at 17:10.

  2. #2
    Join Date
    Apr 2004
    Posts
    130

    Re: Converting MDB to MySQL? Thoughts anyone

    For what its worth, ColdFusion supports links to an Access MDB. Works like a charm!

    Winston Abernathy

  3. #3
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I personally love ColdFusion, I program in it myself. There are many methods. I hear FrontPage can link to Access on the web as well. Then of course there is PHP or ASP.

    Hope that helps a bit,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  4. #4
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    mySQL comes with an ODBC driver.

    So working with mySQL should not be much different than being connected to a SQL Server backend.

    I assume you should be able to export table definitions and data. Make Links. Import. etc., just like any other ODBC database.
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  5. #5
    Join Date
    Nov 2003
    Posts
    104
    Quote Originally Posted by PracticalProgram
    mySQL comes with an ODBC driver.

    So working with mySQL should not be much different than being connected to a SQL Server backend.

    I assume you should be able to export table definitions and data. Make Links. Import. etc., just like any other ODBC database.

    thanx for the feedback Everyone. I know I cna probably get connectivity through ODBC using MySQL to access the tables, etc..

    However, is there a way to export the front end (forms, VBA code, etc...) to save myself from re-creating everything by hand using html/javascript/php ?

    Thanx

Posting Permissions

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