How To Create A Database In MS Access And Link To MySQL Database

How To Create A Database In MS Access And Link To MySQL Database

Check out and follow these easy steps with this video tutorial (less than 2 minutes) to learn how to create a database in MS Access and link it an MySQL database using the ever popular ODBC connection.

The acronym ‘OBDC’ stands for ‘Object Database Connectivity’ and has been around for a very long time now which is now considered the standard for creating a gateway to you MS Access link.

As the video shows, you first establish the database source driver, create an established connection (including a quick test) and then you find the MS Access ODBC feature to create and link to your external database (in this case, MySQL) source files or tables.

How To Create A Database In MS Access And Link To MySQL Database

How To Create A Database In MS Access with ODBC

You can also link any other database to MS Access providing it has an ODBC driver for you to create a connection. Even Access tables can be connected this way but to be fair Microsoft Access provides its own direct link option and can even remember any passwords for your external linked tables too.

On a more advanced footing, using Access VBA code means you can automate this as well as consider a smoother option of using the DSN-less connection option which is handy for cross platform database connections (namely the web).

In the VBA code, you would need to call the connection string as it is called; something like:

ODBC;DRIVER={MySQL ODBC 5.1 Driver};Server=myserver; Database=mydatabase;Uid=myusername;Pwd=mypassword;Option=3

This is added to the database object using something like CreateTableDef member which passes the connection string to your external MySQL database.

I haven’t covered this advanced method in any more detail to be fair but you may want to Google this for yourself, there’s plenty on offer!

What external databases have you connect Microsoft Access to and why? Please use the comment box below.

Leave a Reply

Your email address will not be published. Required fields are marked *