Reports slow to print

[sbraudrick]

I have an access-based application that is admittedly over utilized.
(30+MB front end file, 150MB backend file, 20+ users logged in all the
time)

The problem we are experiencing is that many reports are taking an
extremely long time to print. The most noticeable report is never more
than 2-3 pages and consists of the report and one sub-report. The
delay can be more than one minute before the report begins to print.
(A long time if you need to pull up 15-30 different reports to be
printed.)

This only affects reports from within this application, printing from
other applications seems to be normal. Has anyone ever experienced /
found a solution to this problem?

All machines on the network are XP SP2 in a SBS 2003 domain and
printing to shared printers on a separate Server 2000 machine.

Any help / advice is much appreciated!!

 

[Jason Lepack]

Is the report based on a query? If so, how long does it take the
query to run? If that query takes a long time to run then you could
have a query design issue, or an indexing issue. Did this report run
fast before, but it has gotten progressively slower?

These are all fairly educated guesses.

Cheers,
Jason Lepack

 

[Aaron Kempf]

Access MDB does not support this many users or records

move to Access Data Projects it's a lot easier to deal with
you've got profiler
index tuning wizard

MDB is for lamers that can't spelll SQL

 

[Jason Lepack]

"MDB is for lamers that can't spelll SQL"

He think's he's special because he spells "spell" with three l's.

 

[Aaron Kempf]

rofl

that's because I left the extra L for LAME because I was discussing
MDB-fairies

 

[Guest]

You might want to check to see if you have sections that are set to keep
together as well as using Page of Pages. These will often slow printing.
Another issue is if you have the report set to use a specific printer that
might not be available.