Re: Still problem linked table in MS Access: fields are #Deleted

[Grace Coronado]

Thanks for taking sometime to reply. But our problem is not about entering data through the form. Actually dont have problems when we manually entered records through forms (MS Access form updating MySQL tables). What we need to do is to translate our MS Access tables to MySQL without encountering '#deleted' records.

What we have done so far:
1) Migrated our MS Access tables to MySQL. We have used Navicat, Intelligent Converter, MySQL Migration and Export using ODBC from MS Access.
2) The MySQL tables are now re-linked to a new MS Access database.
3) Using table view from MS Access, view the records of the linked MySQL tables. Here, we experienced getting '#deleted' records for some tables. (Some tables were migrated successfully).

As I have mentioned (in #1), we have tried using different migration tools. But it didn't solve the problem. Other things we have tried, is to manipulate the fields, e.g.:

1) date/time - date
2) tinyint for boolean fields
3) add/remove auto increment fields
4) remove primary keys

We have also tried:
1) Inserting records from MS Access table to MySQL table using using Insert action query from Access; and
2) Create a new structure from MySQL (CREATE TABLE) and use INSERT INTO TABLE to add records one by one.

What seems to work is to remove the definition of the primary key/s, at least for some tables. Because there are tables that don't have any key define and the 'deleted' rows still appear.