Query doesn't work in Access, but in Excel Microsoft Query

[Guest]

Hi!

I created a Access query trying to pull some data with about 8,000 lines and
10 columns from our accounting database. This simple query collects data
from just one database file without any criteria involved. However, the
Access query is not running or responding (It freezes!).

The exactly same query I created in Excel Microsoft Query does work well and
show the result within 1 minute. I also create the same query in Crystal
report. It works well too.

I wonder if there is anything I can do to speed up the Access query.

Thank you very much!

 

[Darren]

There are many things you can do from outside access that you can't do from
within.
Strange but true.

Give more details or post the query.

 

[Guest]

Hi! Darren,

Thank you very much for your help! My query is in the following:

SELECT JC3_TransactionDetail.JobNumber, JC3_TransactionDetail.CostCode,
JC3_TransactionDetail.RecordType, JC3_TransactionDetail.TransactionDate,
JC3_TransactionDetail.SourceCode, JC3_TransactionDetail.CostType,
JC3_TransactionDetail.TransactionComment,
JC3_TransactionDetail.TransactionUnits,
JC3_TransactionDetail.TransactionUnitCost,
JC3_TransactionDetail.TransactionAmount
FROM JC3_TransactionDetail
WHERE (((JC3_TransactionDetail.TransactionDate)>=#6/1/2006#));

I actually try to use date range to filter and narrow down the result. The
database file probably contains 150,000 lines in total.