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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Limitation of 255 fields 12
Import Excel with more than 255 columns 1
crosstab query - 255 columns limit 1
Concatenate - 255 character limit 5
"too many crosstab column headers" error - IN DESIGN VIEW!@!?!?!? 2
How do I run a query where the results table will have 392 fields 3
Update Query Field Limits !!! 3

Back
Top