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

Steve Franks 21 Reputation points
2022-05-02T12:57:21.003+00:00

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

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
844 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful