Bug #3133 Possible problem in MyODBC
Submitted: 10 Mar 2004 13:58 Modified: 11 Mar 2004 15:16
Reporter: G Herrick Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.5.1 OS:Windows (Windows NT4)
Assigned to: CPU Architecture:Any

[10 Mar 2004 13:58] G Herrick 
Description:
MySQL 4.0 on WIndows with MyODBC and an Access 97 client.
An InnoDB table with an autoincrement primary key.
When a record is added to the table from the Access client, Access shows #Deleted# in the fields. The record is added correctly, and is displayed properly in Access once it has been "refreshed".

Hope that is understandable, and that it helps. Regards and best wishes.

How to repeat:
Do as above.
[11 Mar 2004 15:16] MySQL Verification Team 
I tested with Access 2003 without any problems.

Please read our MyODBC documentation:

4.5 When I insert or update a record in linked tables, I get #Deleted#. How do I overcome from this ?

http://www.mysql.com/products/myodbc/faq_toc.html#DELETED_problem
[17 Mar 2004 6:01] G Herrick 
The problem also occurred in Access 2002.

I read the FAQ page, which I had missed before, and adding a TIMESTAMP field fixes the issue in both versions.

Interesting.

Thanks for the help.