|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 10th, 2009, 07:51 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Why is my Access Queries take a long time to generate?
I used to do the query in less than 30 secs, but using the same method to do
another query, it took more than a minutes to generate the table. Why is it so? 
|
|
#2
December 10th, 2009, 03:04 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Why is my Access Queries take a long time to generate?
There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here. Information on primary keys and relationships would be a nice touch too. Also any indexes. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Weak Access User" wrote: I used to do the query in less than 30 secs, but using the same method to do another query, it took more than a minutes to generate the table. Why is it so?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
