Join query causes my PC to crash.

G

Guest

I have a large table from which I regularly need to extract data. However,
if I try to extract the records by running a join query using a small table
containing my criteria - my PC hangs up. CTRL/ALT/DEL says Access is not
responding. However - if I hand type the data I want extracted from the main
table in the criteria space, the query runs fine. I've tested running the
join query on a subset of my main table and it runs fine. Is this just a
case of my PC not having the horsepower to run a join query on a large table?
 
J

John Vinson

I have a large table from which I regularly need to extract data. However,
if I try to extract the records by running a join query using a small table
containing my criteria - my PC hangs up. CTRL/ALT/DEL says Access is not
responding. However - if I hand type the data I want extracted from the main
table in the criteria space, the query runs fine. I've tested running the
join query on a subset of my main table and it runs fine. Is this just a
case of my PC not having the horsepower to run a join query on a large table?

It's more likely the indexing. Do you have indexes on all of the
fields being used as criteria? Could you perhaps post the SQL view of
the query? What is "large" in your context - 10000 rows (very modest)
or 10,000,000 rows (that's getting pretty big)?

John W. Vinson[MVP]
 
G

Guest

Thanks John. That did the trick. I'm a novice user, and didn't know about
indexing. I set my criteria field to be indexed and the query ran in an
instant!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top