Make Table Query - very slow

I

Icmeler

I have a Make Table Query which is based on a Crosstab Query.
When I run the query it is not too slow. However, when I try to access the
design of it, this can take up to an hour to open.
Would anyone have any ideas as to what the problem may be?
Thank you
 
A

Allen Browne

In addition to the crucial aspects listed in the Access Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm
such as disabling Name AutoCorrect and turning off Subdatasheets, the
special case that applies to the crosstab query is that Access has to run it
to completion to determine what the field names will be.

You can probably circumvent that by listing all the possible values in the
Column Headings property of the query. In query design view of your
crosstab, open the Properties box (View menu), and list the values beside
the Column Headings property, e.g.:
"rabbit", "cat", "dog", ...
 
Top