Moved a working MS Access application from Win2000 (version 5.0 SP 3)
OS with MS Access 2000 and DB2 Run-time client v7.1 FP 4 to XP (version
5.1, SP 2) OS with MS Access 2003 and DB2 Run-time client v8.1 FP 5.
This application has linked in objects some of which are Access tables
and others are Db2 tables and views.  ODBC is used for connectivity.
When I run the mdb from the XP-Access2003-Db2v8 machine (also from
Win2000 (version 5.0 SP 3) OS with MS Access 2000 and DB2 Workgroup
Server Edition v8.1 FP 5) I get the following error "Run-time error
3231; ODBC--Field would be too long; data truncated.".  But, when I run
the SAME mdb from a machine with Win2000-Access2000-DB2v7, no error
displays and the application runs flawlessly.  I have looked at the
references in Access and made all the selections possible only to get
the same error.  The query that populates the form runs fine when I
execute it by itself from the query tab in Access.  On both machines
the Access ODBC driver is version 2.50 and regedit showed an entry for
the IBM DB2 ODBC driver but no version.  At this point I am of the
opinion that the problem is between DB2 v8 and Access.  Is there an
ODBC setting in patch1 or patch2 that I could set or make some entry in
the ini file that will relieve this run-time error?  Or another
suggestion?!!   I have exhausted all my ideas--please help.  Thank you.