HELP: ODBC Connector not working correctly

[Dale Logan]

Note: I am not a developer and don't understand how this connector works. However, it has worked fine for me for years.

I need help determining which version of MySQL Connector/ODBC will work for me. I am using MS Access and need to connect to an external database. From my experience, these connections are very finicky. Corporate just sent me a new laptop and I can't get this connection working. It works just fine on my previous laptop.

Previous laptop: Windows 10 Enterprise. System Type: 64-bit operating system. MySQL Connector/ODBC 8.0 (32-bit). Yes, the only one that works on that 64-bit system is a 32-bit MySQL version.

New Laptop: Windows 11 Enterprise. System Type: 64-bit operating system. When trying to use a 32-bit version I receive a message saying there is an architectural conflict. It sounds like 32-bit is not even an option on Windows 11.

On the new laptop, when setting up a connection to the database I have the option of downloading the tables or creating links to the tables. I can download the tables just fine. However, I need links to the tables. When I choose to create links and then open a link to a table I receive a message saying ODBC call failed. After clicking OK on the message, the table opens, but every field in every record contains #Name?. The field names are there and the rows are there. Just no data.

Any help would be greatly appreciated.

Dale