Queries on a Microsoft Access database linked to MySQL tables failed with errors like ODBC--data out of range and the VBA code not recognizing fields from a sub-form query definition, insisting that it could not find the fields that I was referencing (Microsoft Access cannot find the field "fieldname" referred to in your expression).
KB102704
Recently I purchased a new Windows 8.1 machine and installed most of the relevant software that I had on my Windows Vista machine that I eventually plan to retire. I was pulling my hair out trying to figure out why some of the forms and queries on a Microsoft Access database linked to MySQL tables were failing with errors like ODBC--data out of range and the VBA code not recognizing fields from a sub-form query definition, insisting that it could not find the fields that I was referencing.
I searched the internet on the following phrases:
1. Microsoft Access cannot find the field "|" referred to in your expression
2. ODBC--data out of range
I had installed the latest MySQL version and ODBC connector version (mysql-connector-odbc-5.3.4-win32.msi). I could not find adequate help on this problem on the internet. Then I tried installing previous versions of the ODBC connectors. Finally after trying mysql-connector-odbc-3.51.12-win32.msi, the linked database worked properly.
mysql-connector-odbc-5.1.13-win32.msi, which is just one version up from the one that worked, also failed. The key here is that it was not the newer version of MySQL that was the problem, or even the new windows 8.1 operating system, instead it was the connector.
I hope that this helps someone else.
Also, if anyone wants to know, Paradox 9 installs without problems on Windows 8.1 (and so do newer versions of Paradox) but the problem with the Paradox Distribution Expert still exists as it did with windows 7, so it does not install properly. Why the distribution expert installed without problems on VISTA is a mystery to me, considering that VISTA and Windows 7 are very similar. If anyone has a solution to this problem I would appreciate hearing about it (lageenterprises@rogers.com)
Access
Print This
