Connect Access 365 to Mysql connector problem

[TorsteinKrogh]

Hello. On the Mysql.com there is an article "6.4.3 Using Microsoft Access as a Front-end to Mysql". It does not work.
After installing the current ODBC driver, no Mysql option shows when I try to create an ODBC connection.

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[cheekybuddha]

Hello. On the Mysql.com there is an article "6.4.3 Using Microsoft Access as a Front-end to Mysql". It does not work.
After installing the current ODBC driver, no Mysql option shows when I try to create an ODBC connection.

Which version of the MySQL docs are you looking at.

In most recent 8.4, the section you mention no longer exists:

Show us the code you are using and tell us where it fails.

There can be many points of failure, eg open ports on server, ODBC options and connection string, etc , etc ...

What version of MySQL Server are you using, and what version and bitness of MyODBC connector?

What bitness of Access are you using?

The more info you can give us, the easier it will be to get you going.

 

[sonic8]

After installing the current ODBC driver, no Mysql option shows when I try to create an ODBC connection.

Did you pay attention to the referenced article saying:

To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.3, “Configuring a Connector/ODBC DSN on Windows”;

In most recent 8.4, the section you mention no longer exists:

It still exists. It is not part of the main MySql documentation but of the ODBC Connector documentation: https://dev.mysql.com/doc/connector...examples-tools-with-access-linked-tables.html

 

[cheekybuddha]

It still exists.

Yes, I already found it, and made another whole post that seems to have disappeared

Probably lost by a mod trying to move this part of the thread out of the Introduce Yourself board. (Or perhaps I never hit 'Post reply' and refreshed my browser? )

 

[RonPaii]

This is a nice little utility to generate connection strings.
Open it and configure your settings.
Click OK
Edit the file to get the saved string.