How can I read MYSQL (MariaDB) Data using MS Access

Question

I use digikam to manage my photos and would like to perform analyses on the data, which is held in a MariaDB Internal MYSQL database.
The only connectors that I have found in Access are for Microsoft SQL Server. I tried to create a new connector:-
Driver={MySQL ODBC 5.2 ANSI Driver};
Server=127.0.0.1;
Port=3307;
Database=digikam;
User=myUsername;
Password=myPassword;
Option=3;

This data works with HeidiSQL, but Access replaces the driver name with Dbase 5.
What am I doing wrong?
Thanks in advance
Steve

Answer 1

For Mysql you need Mysql ODBC connector: https://dev.mysql.com/downloads/connector/odbc/

Also read this: https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html

For MariaDB I think there is also a connector but don't know if those tips for mysql apply here too.