4 ms·

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 tal

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.

stareatgoats 6y ago
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/ 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 :-)