I think you will need to give more specific information about what exactly you tried to
do, what you expected to happen and what actually did happen. I am not sure what you mean
by "SET type field". You can't change the column type on an ODBC table from Access if that
is what you mean. You would need to do that using MySQL tools and then refresh the table
connection in Access.
Carl Zeiss Vision Australia (Asia Pacific)
Global Business Solutions/Customer Enablement
J o h n B o n n e t t
Phone: +61 (0) 8 8392 8307
Fax: +61 (0) 8 8392 8160
This email, including any attachments, is intended for the sole use of the intended
recipient(s) and may contain information that is confidential, privileged and/or the
Any review or distribution by any other person is prohibited. If you are not an intended
recipient, please immediately contact the sender and delete all copies.
From: 重 博光 [mailto:hirobon@stripped]
Sent: Sunday, 23 February 2014 5:26 PM
Subject: How to treat the SET type field?
Hello MySQL people! I'm hirobon from Kobe,Japan.
How to treat the SET type field on MySQL with Connector/ODBC and MS Access2013.
I'm trying to access MySQL database with ODBC and MS Access2013.
The database connection is success.But I can not access the SET type field on MySQL table.
Any error messages and log files are not exist.
Thank you for any help.
Operating system and version: Windows7 SP1
Connector/ODBC version: 6.1.7601.7632
ODBC Driver Manager type and version: 6.1.7601.17514
MySQL server version: 5.1.69
ODBC trace from Driver Manager: none
Connector/ODBC log file from Connector/ODBC driver: none
Simple reproducible sample: none
This message is intended for a particular addressee only and may contain business or
If you have received this email in error, please contact the sender and delete the message
immediately. Any use of this email, including saving, publishing, copying, replication or
forwarding of the message or the contents is not permitted.