255 column/field limit

C

Chris W

Hello, I have a user trying to link to a table (DB2 in this case) which
contains 312 columns. Only the first 255 columns are returned. Is there any
MS Access work-around for this and is this limit of 255 columns/fields
carried through in more current versions of MS Access? I could split the DB2
table into multiple smaller tables but this is an Enterprise DW and would
prefer not to impose design restrictions on the Enterprise D/B premised upon
external tool limitations.
TIA. Chris.
 
D

Duane Hookom

The 255 column limit is imposed on all versions of Access. You could create
pass-through queries to your DB2 table that would return subsets of fields.
 
C

Chris W

Thanks for the response and suggestion.
The 255 column limit is imposed on all versions of Access. You could create
pass-through queries to your DB2 table that would return subsets of fields.
Click to expand...
 
Top