Field/column limit

  • Thread starter Thread starter pemt
  • Start date Start date
P

pemt

Dear,

My query will produce a table of 2,000 Fields and 10,000 rows. Is there any
way to extend field/column limitation in Acess?
Thanks,

Pemt
 
I'm assuming that is some kind of crosstab query? If so you are way past
the crosstab limit.

If so run a regular sql query (that's many more rows and less columns) and
use code to produce a text file or something by looping through the query.

Access2007 has bigger limits I think on crosstabs.

If it's a regular query and you have that many fields perhaps you can
redesign in a way that works.

Mark
 
None that I'm aware of.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top