MySQL Forums
Forum List  »  Connector/ODBC

Re: MS Access crashes when opening an MySql table
Posted by: Bogdan Degtyariov
Date: November 09, 2020 07:47PM

The bug is now fixed and JSON column type is now supported by ODBC Connector.
In MS Access JSON data will be editable only if there is another column that
can be used as a primary key.
Because JSON is a long data type with the max length of 4Gb it could not be
used as a primary key by MS Access and therefore the tables having only JSON
columns will be available in read-only mode.
The patch should be released with the next version of MySQL Connector/ODBC.
We cannot provide the release date before the official announcement is made.

Options: ReplyQuote

Written By
Re: MS Access crashes when opening an MySql table
November 09, 2020 07:47PM

Sorry, you can't reply to this topic. It has been closed.

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.