db2 linked tables return "#Deleted"

[Ryan Kane]

Just upgraded from DB2 v7.2 to v8.

After the upgrade, all of the tables that use a BIGINT field as a primary
key return "#Deleted" for all results, and likewise show "#Deleted" when you
simply open the table to view it.

This ONLY occurs on tables with a BIGINT field as a primary key (which
access shows as being a TEXT field). Any clue on a fix to this?

I've already installed DB2 fixpack 9a and had no luck.

Using any program besides Access works fine (winsql, crystal reports 9.0, etc)

I'm using access 2003.

Thanks!

 

[Ryan Kane]

Just found an alternate solution that worked!

(Searched the IBM DB2 help site)

In the db2cli.ini file, there are headers for each DB2 DSN that you have
setup. Under the one that is giving you a problem, you have to add the
following line:

MapBigintCDefault = 1

After adding this line, I simply restarted Access and everything started
working.

Thanks anyway, though!