Report Running Very Slow

[ryguy7272]

I have a report that is based on three Queries, all of which are fairly
complex. The Report seems to be running very slow! Just adding Field Names
to the Report, for instance, causes Access to freeze for almost 30 seconds.
Am I doing something wrong? Is there some kind of setting that I can check?
Do the Queries re-run each time any kind of change is made ot the Report?

Thanks for the help and advice!!
Ryan---

 

[Allen Browne]

Tho answer to your final question ("Do the queries re-run every time...?"),
is Sometimes.

Cases where they do include:
a) Layout view (in Access 2007).
Use Design view instead.

b) Reports based on crosstab queries (since the query has to run before the
column headings are known.) To solve this, use the Column Headings property
in the crosstab query to list all the possible headings so JET knows them
without having to run the query.

Even in design view when it is not a crosstab, Access does read the schema
behind the tables in the queries. If other people are using the same data at
the same time acorss a network, this can be slow. It might help to make a
copy of the data file (assuming attached tables) on your local hard disk and
connect to that (linked table manager) while designing your reports.

At worst, temporarily turn the report's source query into a Make Table, and
connect the report to this local table until you complete the report design.