Coouldn't connect Access to MariaDb

[Neelix]

I would connect MS Access 2021 on a win8 machine to my MariaDb server 10.6.16 on an Ubuntu 22.04 machine.



I installed MariaDb ODBC connector and created a DSN. When I test it, it said :

Connection successfully established

But, when linking MS Access to my DSN, I go the message :

[ma-3.1.20]No data source or driver specified; dialog prohibited [#0]

Could someone help, please ?

[ranman256]

when you created the DSN, did you click TEST DATA SOURCE? did it say successful?
if not you need a new driver.

[Neelix]

Yes I do. I apologize, I didn't explain clearly.

I did test the DSN and it said :

Connection successfully established

[Neelix]

So, I tried to connect Access with a mySQL driver. It connects successfull to database but it is unable to read table content.