Bug #17679 Bigint toINT functionality seems broken

Description:
Connecting with MSACCESS 2003 to MySQL 5.0.16 to a newly created database and tables, the dreaded #deleted# bug showed up again.
Changing the datatype of the primary key from Bigint to INT solved the issue.

All the other fixes/workarounds suggested here:

http://dev.mysql.com/doc/refman/5.1/en/deleted-problem.html

have been tried and had no effect.

How to repeat:
Create new database, empty table like this one:
reate table BICCategories
(
    IDBic                     BIGINT unsigned       not null  AUTO_INCREMENT PRIMARY KEY,
    Code                      CHAR(255)             null      ,
    Description               CHAR(255)             null      ,
    Remark                    TEXT                  null      ,
    SISOCode                  CHAR(50)              null      ,
    OldID                     BIGINT unsigned       null      ,
    TS                        TIMESTAMP             not null        default NOW(),
    TS2                       TIMESTAMP             not null       default '2006-02-23 20:25:20'
)
TYPE= InnoDB;

Create ODBC DSN
Check 
x Don't Optimize Column Width
x Return Matching Rows
x Allow Big Results
x Change BIGINT Columns To INT

Create table link in Access 2003 

add record

#deleted# shows

Thank you for a problem report. What exact version of Connector/ODBC do you use?

Sorry forgotten that, I use the 3.51.12 ODBC connector

Newsflash: Just upgraded the server to 5.0.18 same difference;-) ie problem persists. I also created a new database and a new table that had no effect.

Thanks for your bug report.  I was able to reproduce this using 3.51.12 and Access 2003

fix connector/odbc version

Is there any update to this... what can we do to get around it?

COLUMN_SIZE was still the wrong value for Access, even when FLAG_NO_BIGINT was set

Also, BIGINT should work fine with Access now since Bug#24535 is fixed.

Verified with the latest revision (801). MS Access is not able to read BIGINT values properly from the table with just two columns (BIGINT and VARCHAR).
#DELETE appears instead of real values.

Will be released in 5.1.6

An entry was added to the 5.1.6 changelog:

Microsoft Access was not able to read BIGINT values properly from a table with just two columns of type BIGINT and VARCHAR. #DELETE appeared instead of the correct values.

Pathch has been backported to 3.51 and pushed as rev#704. Will be in 3.51.28 release

(ported to 3.51)

Changelog entry updated to include version 3.51.28.