[AccessD] ODBC driver for Access 2019 to MySQL

[Paul Wolstenholme]

My go to place for driver knowledge would be
https://www.connectionstrings.com/mysql/
I see you have an ADODB alternative.

Paul Wolstenholme


On Thu, 28 Apr 2022 at 03:36, John Bartow <jbartow at winhaven.net> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>