1
I have an MS-ACCESS 2003 application with linked tables located in MySQL 5.7.25.
The Forms and Queries work correctly with the linked tables, as long as the tables include up to X records, depend which table.
When a table exceeded X records, there is one of 2 problems (depend which table):
A table with 4-5 fields (works well with about up to 200 records): When opening the table in ACCESS in View mode, I get the "ODBC - call failed" message, and all fields have "#Name?" value. But, when accessing the table data from the Forms, the data is displayed OK.
A table, with 20 fields (works well only up to 100 records): In View mode in ACCESS, I can see all data correctly. But I cannot access the data from my Forms. The table and fields are not recognized in the code.
When working with these table directly from Access (not as linked tables) - all works correctly, no matter how many records are in the tables.
Hope you can help me with these issues. THANKS!
The auto reconnent is set. I already tried all other parameters. Nothibg helps to solve the problem. – Efrat – 2019-05-06T12:22:03.010