I am having a similar issue as the user here: http://www.access-programmers.co.uk/forums/showthread.php?t=185520
I have a query which is a basic select query on a few different linked tables. It saves quite quickly. However, when I add a crosstab query in the mix it takes a couple of minutes to save. If I remove the crosstab query it saves within seconds.
The crosstab query is a simple crosstab on a linked table. Nothing special. If I add the linked table and not the crosstab to the linked table it saves quickly. I can't run it this way, but I was just testing if there was an issue with the original table.
Any ideas on why this would be so slow?
I have a query which is a basic select query on a few different linked tables. It saves quite quickly. However, when I add a crosstab query in the mix it takes a couple of minutes to save. If I remove the crosstab query it saves within seconds.
The crosstab query is a simple crosstab on a linked table. Nothing special. If I add the linked table and not the crosstab to the linked table it saves quickly. I can't run it this way, but I was just testing if there was an issue with the original table.
Any ideas on why this would be so slow?
