I have a report hooked to a pass though query. When I print the report, the records spools much slower than if I print a report linked to a table. It shows the report printing and the pages 1.2.3.4....10 cycle slower than when using a linked table. I assume this is because the record set is not entirly retrieved when using a pass through query and Access is pulling back the records when printing. Is there any way to speed this up?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pass Through Query Report Spools Slowly
- Thread starter ideafixer
- Start date
Does your report display Page of Pages?
I have created reports where records were pulled from a pass-through into a temporary table and then reported.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
I have created reports where records were pulled from a pass-through into a temporary table and then reported.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Status
Similar threads
- Locked
- Question
