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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|