255 column/field limit

[Guest]

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.

 

[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.

 

[Guest]

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.