Hacker News new | ask | show | jobs
by daniellarusso 2044 days ago
I had actually considered doing this recently with a new hire.

I purchased them a license with Access included, but ai have not had time to play with it to talk to MySQL 5.6.

1 comments

It is embarrassingly easy, once you get over the (minimal) hurdle of setting up the ODBC connections, docs over here for MySQL 5.6: https://dev.mysql.com/doc/connector-odbc/en/

In MSAccess, just go to "External Data" -> "New Data Source" -> "From Other Sources" -> "ODBC Databases" (chose whether to link or import the data) and then create a new data source under "Machine Data Sources" using the MySQL driver.

It became like muscle memory after a while :-)