I have linked a DB2 UDB table containing BIGINT Data type from access.
When I display the data all the column shows up as #Error .
I linked a similar table without the BIGINT column and It displays the data correctly.
I checked the datatype in the access design view and the DB2 BIGINT Field has a data type of Binary in access.
I tried displaying the Data from crystal reports using the ODBC (IBM provided) & the native driver and the BIGINT column displays fine.
The problem is with JET, the database driver for MS Access.
The Microsoft article explaining the problem is article #Q279515. In it, they list the fix for the issue, and an explanation that the service packs must be installed in
the correct order: