Join query causes my PC to crash.

[cdris7319]

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?

 

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

 

[cdris7319]

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!