[AccessD] ODBC driver for Access 2019 to MySQL

[Ryan W]

https://dev.mysql.com/downloads/connector/odbc/


Install the proper connector based on your access bitness and then on the server side set the appropriate grants to allow connections from your IP address. (May not have to do this depending on the server side config)


Sent from my iPhone

> On Apr 27, 2022, at 4:44 AM, John Colby <jwcolby at gmail.com> wrote:
> 
> Does Microsoft allow Access to connect (link) to MySQL?
> 
> I have a MySQL database on my web site.  It exists, has data, I have a user
> and password.  I need to connect Access to that database.
> 
> I am trying to create a dsn file and MySQL is not a choice for drivers.  In
> fact the choices are distinctly slim pickings.  Mostl sql server.
> 
> Can anyone help me get this done?
> 
> -- 
> John W. Colby
> Colby Consulting
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com