Access Crashes - possible to run in background?

[jakobt]

Everytime I run access query. My Access database screen freezes.

Is there anywhere I can let Access query run in background and close the database and open it later to see if the query is ready?

 

[Joe4]

I don't know about that, but I think you need to look at ways of improving the efficiency of the query.
Seeing as how we really know nothing about your database, we need to learn more about it in order to know what to recommend.

How big is your database? How many records and fields of data do you have?
Is all the data internal to this Access database, or is it linked to data elsewhere?
Do you have a Primary Key and Indexes on your data fields?
What exactly is the query doing?
Do you regularly Compact and Repair the database?

 

[Micron]

A major reason for slowness can be running over WiFi. Likely that your query is inefficient (as noted). Performing aggregate functions on table fields can certainly slow things down, especially if the data is sql or ODBC based.