[AccessD] ODBC driver for Access 2019 to MySQL

[John Bartow]

Yes. I download a SQL DB export from my RMM provider and run Access queries and reports against it. Wish I could do it live but that's not allowed so its just a little routine I have to run. All of the info I needed to set it up was on the MySQL web site.

John B

-----Original Message-----
From: AccessD <accessd-bounces+jbartow=winhaven.net at databaseadvisors.com> On Behalf Of John Colby
Sent: Wednesday, April 27, 2022 4:44 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>; John W Colby <jwcolby at gmail.com>
Subject: [AccessD] ODBC driver for Access 2019 to MySQL

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