255 column/field limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris W - 21 Sep 2006 22:05 GMT

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.

Reply to this Message

Duane Hookom - 21 Sep 2006 22:16 GMT

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.

Signature

Duane Hookom
MS Access MVP

> 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
[quoted text clipped - 7 lines]
> external tool limitations.
> TIA. Chris.

Reply to this Message

Chris W - 22 Sep 2006 14:23 GMT

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.
[quoted text clipped - 10 lines]
> > external tool limitations.
> > TIA. Chris.

Reply to this Message