MySQL Forums
Forum List  »  Connector/ODBC

Advanced Search
New Topic

Re: mysql-connector-odbc-8.0.23 and MS Access cannot link MYSQL table with compound primary key
Posted by: Bogdan Degtyariov
Date: May 16, 2021 06:15PM

MySQL ODBC Driver 8.0.24 and MS Access from Office 365 worked for me when I tried using table like yours:

CREATE TABLE stations ( station CHAR, date DATE, PRIMARY KEY (station, date))

It did not prompt me to pick the primary keys because they were correctly detected.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
mysql-connector-odbc-8.0.23 and MS Access cannot link MYSQL table with compound primary key
Martin Pfannkuchen
January 27, 2021 05:47AM
Re: mysql-connector-odbc-8.0.23 and MS Access cannot link MYSQL table with compound primary key
Bogdan Degtyariov
May 16, 2021 06:15PM


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.