[AccessD] ODBC driver for Access 2019 to MySQL

[John Colby]

Thanks for this.  I knew I had seen this page.

On Wed, Apr 27, 2022 at 4:42 PM Paul Wolstenholme <
Paul.W at industrialcontrol.co.nz> wrote:

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


-- 
John W. Colby
Colby Consulting