The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

ODBC/Win7/MS Access 2016 and Linux MariaDB

Using ODBC Win7/Access 2016 and MySql 5.3.4 driver (had to revert back to older driver to get ODBC connection) to Linux/MariaDB. Problem- Table Views. When table is larger than 255 fields Access cannot read and requires a table view to split the table. It is my understanding that the table view uses the underlying table primary key therefore, one is not designated in the view.

ODBC call fails if the primary key is designated when creating the link in Access. If no primary key is designated, ODBC call functions however in read only mode preventing updates. Connection to all standard tables function in edit mode works. Have tried multiple drivers including mariadb driver in Win10/Office 365 on local machine which does not function. Not sure if it is our set up or ongoing bug but this occurred within the last 30 days. Connection had been functioning correctly to that point. Any help would be appreciated. Thank you.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.