Field/column limit

[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

 

[Duane Hookom]

No. I can't imagine a good business justification for more than 25-45 fields.

 

[BILLYJOE]

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

 

[Mark Andrews]

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

 

[BILLYJOE]

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

 

[Jeff Boyce]

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.

 

[jamie liddle]