255 column/field limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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...
 
Back
Top