DB2/400 ODBC link Imports Wrong Fieldsize

[Tom]

Trying to link to a DB2/400 table using IBM Client Access
Expess ODBC Driver. Link is sucessfully created, but on
attempting to open the table I get an error indicating a
numeric value is out of range. (I get the same error
trying to import as well as link.) Field1 in table on the
AS400 is 6 digit numeric. In Access Linked Table
Properties, Field1 is a Number, Fieldsize Integer. The
first value in Field1 is 380000, which is obviously to big
for the Integer fieldsize, which causes the error. Field
properties on linked tables cannot be modified. Any way
around this?

 

[Joe Fallon]

1. Don't open the table directly.
2. Write a query instead.
Omit the offending field.

If you need to use it I am not sure if you can convert it in the quey
(divide by 1000 or something) or if you can't use it at all.