MySQL Forums
Forum List  »  Microsoft Access

ACCESS 2003 and MySQL - problems with linked tables
Posted by: Efrat Malkin
Date: April 27, 2019 11:18AM

Hi,
I have an application developed via MS-ACCESS 2003.
I migrated the data (ACCESS tables) to a MySQL 5.7.25.
Then, I linked the MySQL tables to the ACCESS.
Most of data works correctly (viewing the tables content and accessing the data via the Forms).
I have a problem with 2 table:

1. Table contains list of activities (5 fields per record): up to 210 records, all works fine. After adding record no. 211, there is a problem:
when opening the table in ACCESS in view mode, I get the "ODBC - call failed" message, and only 86 records are displayed, where all fields have "#Name?" value.
But, when accessing the table data from the Forms, the data is OK.

2. Table contains list of people details (name, address, etc.): In case of few records in this table, all works fine. But when using the full data (197 records), there is a problem:
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.

Hope you can help me with these issues. THANKS!

Options: ReplyQuote


Subject
Views
Written By
Posted
ACCESS 2003 and MySQL - problems with linked tables
116
April 27, 2019 11:18AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.