S
Sandy Ramsey
I have an Access 2002 database application. BE is only about 25MB located on
a NT4 server. The front end is an MDE file located on the local workstations
(XP, 512 RAM, 40Gig HD) running Access Runtime (scripts built by SageKey). I
have a report based on a query (pulls about 10K records w/o the where clause
that is used prior to printing narrowing it to one record). There is code in
the report that sets a number of variables based on loops through recordsets.
In order to get the printer to see all 4 copies as one job and staple it I
have a report shell with 4 subreports (all identical) which creates 4 copies
of the ticket. So I realize it is processing the data 4 times. The ticket
does have a logo and a lot of lines (like filling in a form). It works fine
but runs slow. The printer (Gestetner DSm627 RPCS) is setup with it's own IP
address on the server.
After hitting the print button it is now taking almost 60 seconds to start
printing. Opening the print que window shows it spooling for most of the
time and then it counts off the pages 1/4 etc. It use to be faster but seems
to keep slowing down. All my other basic reports (even a 86 page customer
list) starts printing right away.
I have compiled / even created a new database and imported in all the
objects w/o any change.
My question is what type of memory/temp files (an where - server vs client)
does Access use to process/spool and print reports? Just RAM / Virtural
Memory / temporary spool folders / ??
Any help would be greatly appreciated.
a NT4 server. The front end is an MDE file located on the local workstations
(XP, 512 RAM, 40Gig HD) running Access Runtime (scripts built by SageKey). I
have a report based on a query (pulls about 10K records w/o the where clause
that is used prior to printing narrowing it to one record). There is code in
the report that sets a number of variables based on loops through recordsets.
In order to get the printer to see all 4 copies as one job and staple it I
have a report shell with 4 subreports (all identical) which creates 4 copies
of the ticket. So I realize it is processing the data 4 times. The ticket
does have a logo and a lot of lines (like filling in a form). It works fine
but runs slow. The printer (Gestetner DSm627 RPCS) is setup with it's own IP
address on the server.
After hitting the print button it is now taking almost 60 seconds to start
printing. Opening the print que window shows it spooling for most of the
time and then it counts off the pages 1/4 etc. It use to be faster but seems
to keep slowing down. All my other basic reports (even a 86 page customer
list) starts printing right away.
I have compiled / even created a new database and imported in all the
objects w/o any change.
My question is what type of memory/temp files (an where - server vs client)
does Access use to process/spool and print reports? Just RAM / Virtural
Memory / temporary spool folders / ??
Any help would be greatly appreciated.