Long running report

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I built an accounting system in Access 2000. The system
has several tables, queries, forms and reports.
Everything runs fine except for 1 report which takes in
excess of 5 hours to run. It has a number of queries that
supply it data, each of those run in less than 1 minute.
It has 3 sub-reports, each of which run in less than 1
minute. When I put everything together, it drags to a
halt. What am I doing wrong?

Thanks,

Ray
 
If you have [Page] of [Pages], this may slow your report to a crawl.
Otherwise, it may be beneficial to create temporary tables from your queries
and then base the reports on the temp tables. I have built apps that
dynamically create a separate MDB for the temp tables. This cuts down on
bloat in your application mdb.
 
Duane,

Thanks, taking "of [Pages]" off sped it up quite a bit.
That got me down to just less than 3 hours. Do you have
some sample code for creating the temp tables? I've never
done that before.

Thanks,

Ray
-----Original Message-----
If you have [Page] of [Pages], this may slow your report to a crawl.
Otherwise, it may be beneficial to create temporary tables from your queries
and then base the reports on the temp tables. I have built apps that
dynamically create a separate MDB for the temp tables. This cuts down on
bloat in your application mdb.

--
Duane Hookom
MS Access MVP


I built an accounting system in Access 2000. The system
has several tables, queries, forms and reports.
Everything runs fine except for 1 report which takes in
excess of 5 hours to run. It has a number of queries that
supply it data, each of those run in less than 1 minute.
It has 3 sub-reports, each of which run in less than 1
minute. When I put everything together, it drags to a
halt. What am I doing wrong?

Thanks,

Ray
Click to expand...


.
Click to expand...
 
I can't find my previous code that creates a temporary database. I used the
CreateDatabase() function and then DAO code to create the temp tables.
Change some of your select queries into either Make Table queries or Delete
then Append queries.

--
Duane Hookom
MS Access MVP


Ray said:
Duane,

Thanks, taking "of [Pages]" off sped it up quite a bit.
That got me down to just less than 3 hours. Do you have
some sample code for creating the temp tables? I've never
done that before.

Thanks,

Ray
-----Original Message-----
If you have [Page] of [Pages], this may slow your report to a crawl.
Otherwise, it may be beneficial to create temporary tables from your queries
and then base the reports on the temp tables. I have built apps that
dynamically create a separate MDB for the temp tables. This cuts down on
bloat in your application mdb.

--
Duane Hookom
MS Access MVP


I built an accounting system in Access 2000. The system
has several tables, queries, forms and reports.
Everything runs fine except for 1 report which takes in
excess of 5 hours to run. It has a number of queries that
supply it data, each of those run in less than 1 minute.
It has 3 sub-reports, each of which run in less than 1
minute. When I put everything together, it drags to a
halt. What am I doing wrong?

Thanks,

Ray
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top