Recent content by EFRAT_MA

  1. E

    ACCESS 2003 and MySQL - problems with linked tables

    Thanks a lot for your help. changing to"MySQL ODBC 8.0 ANSI Driver" solved the problem.
  2. E

    ACCESS 2003 and MySQL - problems with linked tables

    The ODBC Device Driver is: "MySQL ODBC 8.0 Unicode Driver". Now I defined "MySQL ODBC 8.0 ANSI Driver", and in some cases it works. May be this is the reason for the problem? Continue checking and I will update you.
  3. E

    ACCESS 2003 and MySQL - problems with linked tables

    OK, I was able to isolate the problem: The problem occurs when viewing all table records. When retrieving one specific record (or few records), everything works properly. But I have to show ALL records. Maybe anyway this is a TIMEOUT problem? How can I check it? How can it be solved? (Auto...
  4. E

    ACCESS 2003 and MySQL - problems with linked tables

    Regarding issue #1, I created a very simple table (for test) with 3 fields: 1. Primary key - INT(11) - sequential number starting with "1" 2. FLD1 - VARCHAR(50) 3. FLD2 - VARCHAR(50) Regarding issue #2: When trying to display a Form with the table data, I get the Run-Time error 2113: "‏The...
  5. E

    ACCESS 2003 and MySQL - problems with linked tables

    Yes. The primaty key is int(11).
  6. E

    ACCESS 2003 and MySQL - problems with linked tables

    Hi, The Auto Reconnect flag is set. How can I check if it is indeed timeout problem? Hoe to solve it?
  7. E

    ACCESS 2003 and MySQL - problems with linked tables

    Hi, 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)...
Back
Top Bottom