Variable MySQL driver version in connection string (1 Viewer)

Hi there,



I'm connecting from my Access FE to a MySQL BE database. This is my connection string:


Now I would like to make this independent from a specific ODBC driver version so that any installed version will work to establish the connection. For this, the driver must be detected via ODBC. Has anyone ever done this & is there a working solution out there? Thanks for help.


Best, Frank

Have a read of this to get the drivers on a machine;

https://social.msdn.microsoft.com/F...e-local-machine-by-way-of-vba?forum=accessdev

Sure that can help. I do have a routine to check for a specific driver but can't lay my hands on it right now.

Nice, I'll give it a try... thx!