Microsoft Access with ODBC-Connector 8

[Ernst Stephan Kraft]

For about 15 years we have been using MySQL to store data for MS Access frontends. Until about 3 years ago in version 5.3, since then in version 8.0 with the latest release.

As driver we use the ODBC driver version 5.1.8 (32 bit), although this actually does not fit (anymore) to the MySQL server version.

A change to the current driver version (8.0.33) is not possible.

The driver "MySQL ODBC 8.0 Ansi Driver" often loses the connection to the data source during form filter functions in MS Access Forms. In my opinion, this driver is not suitable for use with MS Access as a frontend.

The driver "MySQL ODBC 8.0 Unicode Driver" on the other hand does not have the "quirks", but a serious bug. Whenever a primary key field contains a German special character (ä, Ä, ö, Ö, ü, Ü, ß), the data record is marked with an error and can no longer be selected or edited.

Maybe sometime in the distant future it will be possible to use the current ODBC driver for the current MySQL server version also under MS Access as frontend.

As we all know, hope dies last.

Many greetings
Stephan