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.
9 thoughts on “Connect Access / OOBase to MySQL Using ODBC Part 1 of 2”
Leave a Comment
You must be logged in to post a comment.
thanks! really are good, and helped ma a lot!
great tutorial , thanks
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!
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.
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
Thanks for this Bruce, it’s quite a handy little intro.
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?
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.
Thanks for the video. But, how about implement these into PHP?