Reports - long time to load

[BahBah]

Out of the blue and at rare times in the day my access reports seem to take 10-15secs longer to load than normal.

I use linked tables if that is relevant.

If I run the queries manually they are fast, which makes me think it must be something to do with the reports themselves and not their recordsets.

They even take some time to open in design view if I open them in design view from the object explorer.

Are there any gotchas regarding this that I may have missed out on ?

Thank you

 

[boblarson]

If the queries run quickly, do you have any grouping, sorting, VBA/Macros running, or Domain Aggregates (DSum, DLookup, DMax, etc.) on the report?

 

[BahBah]

Hello

Thank you for your reply. I have found the problem. I am on a network and the person who shares my default printer had his PC turned off. Access must have been checking to look for the printer as it wasn't available.

 

[boblarson]

Thanks for posting back with the answer.