db2 linked tables return "#Deleted"

R

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!
 
R

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top