MySQL Forums
Forum List  »  Connector/ODBC

Microsoft Access with ODBC-Connector 8
Posted by: Ernst Stephan Kraft
Date: June 06, 2023 12:03AM

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

Options: ReplyQuote

Written By
Microsoft Access with ODBC-Connector 8
June 06, 2023 12:03AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.