Crosstab - "Record is too large"

  • Thread starter Thread starter Liz Hansen
  • Start date Start date
L

Liz Hansen

Hello,

I have a crosstab query that when run displays the following error:

"Record is too large".

It is a large query, I have 235 columns, but as far as I understand I can
have 254 so I should be fine. What else could this error indicate? Maybe
there is a limitation on how many Rows I can have as well?

Thanks,

Liz
 
Record is Too Large means that you are returning too many characters per row.

Access 97 has a limit of 2000 characters - not including memo and ole objects.

I believe the limit is higher in Access 2000 and later -- just checked on line
help and its says Access 2000 is limited to 2000 characters in a row
 
Back
Top