Reports Chokes on Large Recordsets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on an .adp file in Access 2003 connected to a SQL Server 2000
database for a film storage facility. The report that is giving me trouble
is an inventory list displaying all reels belonging to a selected customer,
grouped by title. It is a pretty simple report and works fine most of the
time. However, there are a small of customers who have a huge number of
reels in the library -- over 50,000 -- and when I attempt to run the report
for any of these clients, Access locks up. Eventually, the Windows Task
Manager tells me that the application is not responding, and I am forced to
bail out. How can I fix the report to accommodate very large recordsets?

Thank you for any advice on how to cope with this situation.
 
Sheldon,

If you have page numbering like "Page "&[page]&" of "&
[pages] (which results in Page 1 of 250) you can bog
Access down. Access needs to render all pages before it
can determine the number of pages. If you have this try
removing it. If you don't have this do you have any other
code in the "on format" or "on print" events? Or any
additional information.

HTH

Terry
 
Thank you, Terry!

I did have a "Page x of y" in the header, and when I deleted it, the problem
went away.

Terry said:
Sheldon,

If you have page numbering like "Page "&[page]&" of "&
[pages] (which results in Page 1 of 250) you can bog
Access down. Access needs to render all pages before it
can determine the number of pages. If you have this try
removing it. If you don't have this do you have any other
code in the "on format" or "on print" events? Or any
additional information.

HTH

Terry
-----Original Message-----
I am working on an .adp file in Access 2003 connected to a SQL Server 2000
database for a film storage facility. The report that is giving me trouble
is an inventory list displaying all reels belonging to a selected customer,
grouped by title. It is a pretty simple report and works fine most of the
time. However, there are a small of customers who have a huge number of
reels in the library -- over 50,000 -- and when I attempt to run the report
for any of these clients, Access locks up. Eventually, the Windows Task
Manager tells me that the application is not responding, and I am forced to
bail out. How can I fix the report to accommodate very large recordsets?

Thank you for any advice on how to cope with this situation.
.
Click to expand...
Click to expand...
 
Back
Top