Connect Access / OOBase to MySQL Using ODBC Part 1 of 2

This video demonstrates how to install and configure the MySQL ODBC driver on a Windows-based PC and then use it to connect either Microsoft Access or Open Office Base to a MySQL database. Part 1 of 2.

May 3, 2010 | Filed Under Mysql Tutorials 

Comments

9 Responses to “Connect Access / OOBase to MySQL Using ODBC Part 1 of 2”

  1. silentdognet on December 8th, 2008 2:33 am

    Thanks for the video. But, how about implement these into PHP?

  2. brucefulton on December 8th, 2008 10:19 am

    Not sure what you are looking for. Acccess and PHP are different kinds of tools for different kinds of jobs. PHP can call MySQL directly or it can use ODBC to connect to an Access database. Access directly connects to its own native DB type or connects to MySQL using ODBC. Depending on what kind of application you are writing, you would use PHP or Access.

  3. silentdognet on December 8th, 2008 11:46 am

    Well, what I am looking for is some tutorials for creating simple PHP website (aka web-based application). I guess building one database driven website using PHP are great, isn’t it?

  4. abc0987z on January 4th, 2009 11:39 am

    Thanks for this Bruce, it’s quite a handy little intro.

  5. DarkShroom on May 1st, 2009 10:51 am

    thanks for the tutorial, we need to replace our aging access based customer database with somthing more stable and i think MySQL using OpenOffice or Access as a front end will probabally be the easiest way

  6. MetricStudios on May 9th, 2009 12:48 am

    too bad i cant do any of this 64 bit operating system and they havent even made software compatible yet for any of the databases .mdbc is what i need.

  7. iamghost17 on May 23rd, 2009 4:58 pm

    Very informative tutorial, I really liked it. It misses however the information about the capability of Base using JDBC which I prefer due to several utf8 issues in a mixed Windows/Linux environment. Though the Access ODBC runs pretty well the better choice for Base is JDBC. I even might say that JDBC runs slightly smoother.

    Anyway I like your videos, keep it up. You are doing good work!

  8. lleon596 on December 2nd, 2009 8:13 am

    great tutorial , thanks

  9. dulceligia on February 28th, 2010 11:08 am

    gracias! en realidad eres bueno, y ma ayudado mucho!

Powered by Yahoo! Answers