Big problem printing reports

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

Guest

Help:

I've got a mulit user database that is going way too slow printing reports.
Any suggestions on what could be causing this and what I can do to speed it
up.
 
Robert

The actual "send-to-printer" portion? The "run the query first" portion?
"Too slow" = seconds, minutes, hours?

More info, please...

Jeff Boyce
<Access MVP>
 
Hello Jeff:

It takes about 15-20 seconds to send a report to the printer. There are 20
users on this DB all entering data in the morning and printing off hard copy
reports immediately afterward. SEC regualtions require that we keep hard
copies each day so I can't avoid the reports. I've shortened the path on the
shared drive, compacted and repaired the DB, and have indexed one of the
tables the info is coming from. Still runs slow and even hangs when multi
users are in it running reports. Any suggestions?

Thank you,

Robert
 
Does everyone have their own front-end mdb? As Jeff asked, are the record
source queries slow or just the printing? Do your reports use subreports and
controls that can grow? Do you have [Page] of [Pages] on the reports?
 
Hello Duane:

It's one database on the shared drive that we are all entering data into and
printing reports from. The queries that supply this report run fine. It's
just the printing that's a problem. I've got the end users clicking on a
print button. They are sharing the same queries and reports.

Should I set this up so that each end user has a copy of the database on
their own PC hard drive that is linked to main tables on a seperate database
on the shared drive?

Robert

Duane Hookom said:
Does everyone have their own front-end mdb? As Jeff asked, are the record
source queries slow or just the printing? Do your reports use subreports and
controls that can grow? Do you have [Page] of [Pages] on the reports?

--
Duane Hookom
MS Access MVP
--

RobertM said:
Hello Jeff:

It takes about 15-20 seconds to send a report to the printer. There are 20
users on this DB all entering data in the morning and printing off hard
copy
reports immediately afterward. SEC regualtions require that we keep hard
copies each day so I can't avoid the reports. I've shortened the path on
the
shared drive, compacted and repaired the DB, and have indexed one of the
tables the info is coming from. Still runs slow and even hangs when multi
users are in it running reports. Any suggestions?

Thank you,

Robert
Click to expand...
Click to expand...
 
I would definitely split the application and give everyone their own front
end on a local drive.

--
Duane Hookom
MS Access MVP


RobertM said:
Hello Duane:

It's one database on the shared drive that we are all entering data into
and
printing reports from. The queries that supply this report run fine. It's
just the printing that's a problem. I've got the end users clicking on a
print button. They are sharing the same queries and reports.

Should I set this up so that each end user has a copy of the database on
their own PC hard drive that is linked to main tables on a seperate
database
on the shared drive?

Robert

Duane Hookom said:
Does everyone have their own front-end mdb? As Jeff asked, are the record
source queries slow or just the printing? Do your reports use subreports
and
controls that can grow? Do you have [Page] of [Pages] on the reports?

--
Duane Hookom
MS Access MVP
--

RobertM said:
Hello Jeff:

It takes about 15-20 seconds to send a report to the printer. There are
20
users on this DB all entering data in the morning and printing off hard
copy
reports immediately afterward. SEC regualtions require that we keep
hard
copies each day so I can't avoid the reports. I've shortened the path
on
the
shared drive, compacted and repaired the DB, and have indexed one of
the
tables the info is coming from. Still runs slow and even hangs when
multi
users are in it running reports. Any suggestions?

Thank you,

Robert

:

Robert

The actual "send-to-printer" portion? The "run the query first"
portion?
"Too slow" = seconds, minutes, hours?

More info, please...

Jeff Boyce
<Access MVP>

Help:

I've got a mulit user database that is going way too slow printing
reports.
Any suggestions on what could be causing this and what I can do to
speed
it
up.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top