Access + "Deleted" fields. Directions don't work.
Hi, I have Access XP and MySQL 5.0. I linked 2 tables via MySQL ODBC and if the table doesn't have either a primary index or an autonumeric field, then all goes fine.
But, one of the tables has one INTEGER field, autoincremental, primary key (Field Id) and a field with a String (CHAR (200)). Well, if I link this table from Access and I insert one row, it shows me "Deleted". If I re-open the table, then I see the row correctly. Of course, I need to fix this.
Ok, I followed "all" your directions in
http://dev.mysql.com/doc/refman/5.0/en/myodbc-usagenotes-apptips.html#myodbc-usagenotes-apptips-microsoft-access
but without success.
What can I do?
Subject
Written By
Posted
Access + "Deleted" fields. Directions don't work.
July 04, 2006 12:47AM
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.