MySQL Forums
Forum List  »  Microsoft Access

Re: Still problem linked table in MS Access: fields are #Deleted
Posted by: Grace Coronado
Date: March 06, 2006 03:10AM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.