'MS Access ODBC Connection error - "cannot define field more than once"

Does anybody have some insight on why the following error "cannot define field more than once" comes up in ms access when connecting MySQL tables via ODBC? The only thing I can think of is that I have multiple tables with the same name across other schemas, which may throw things off, but it's pretty important to me to not change a bunch of table names. Thoughts?

Also for reference, I exported to excel one of these problem tables and tried importing to access via excel. The import via excel worked totally fine, which eliminates the possibility of header truncation or duplicates.

mysqlms-accessodbc


Solution 1:[1]

It's a bug. see this link. It indicates that v8.0.26 of the MySQL ODBC connector works. I am using 8.0.25 and it works for me. Apparently there's an 8.0.29 forthcoming that should fix it.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 deluxeinformation

Related Questions