N
Nunzio
I am having a problem running an Access report, and I'm hoping that
someone has run across this before, or can at least offer some
different directions for troubleshooting.
The report runs instantaneously on some machines, but hangs and fails
to render on select other machines. On the problem machines, Access
displays the message "Formatting page - press ctrl+break to stop..."
in the status bar. No error message is ever displayed. The machines
are of comparable power and resources.
The report consists of one main report, and three sub-reports. The
sub-reports are all children of the main report, and are all linked
based on a single key field (a long integer). There is a small amount
of code in the main report, which selectively hides some report
sections. There is no code in any of the sub-reports.
There is nothing out of the ordinary about this report. The machines
that cannot run it ARE able to run other reports.
Troubleshooting steps taken so far:
-Commented out all code
-Changed the default printer to a simple local printer (installed HP
Laserjet III driver for testing purposes)
-I have done some testing using Virtual PC
*The report always hangs in the VPC, and pegs the CPU usage at 100%.
On another (real) machine where the report fails, CPU usage stays
around 50%.
*I have tested using both the runtime and full versions of Access in
the VPC (no difference)
-I have tested on my development machine using combinations of the
RUNTIME switch, and the front end as an .mdb and .mde (the report
always runs fine)
Environment:
Windows XP is running on all machines
Split application
Front end: Access 2002-2003 file format (.mde)
Back end: Access 2000 file format (replicated)
Access 2003 runtime
There is no network involved. Both the front end and back end are on
the same physical machine.
Any help is greatly appreciated.
Thanks.
someone has run across this before, or can at least offer some
different directions for troubleshooting.
The report runs instantaneously on some machines, but hangs and fails
to render on select other machines. On the problem machines, Access
displays the message "Formatting page - press ctrl+break to stop..."
in the status bar. No error message is ever displayed. The machines
are of comparable power and resources.
The report consists of one main report, and three sub-reports. The
sub-reports are all children of the main report, and are all linked
based on a single key field (a long integer). There is a small amount
of code in the main report, which selectively hides some report
sections. There is no code in any of the sub-reports.
There is nothing out of the ordinary about this report. The machines
that cannot run it ARE able to run other reports.
Troubleshooting steps taken so far:
-Commented out all code
-Changed the default printer to a simple local printer (installed HP
Laserjet III driver for testing purposes)
-I have done some testing using Virtual PC
*The report always hangs in the VPC, and pegs the CPU usage at 100%.
On another (real) machine where the report fails, CPU usage stays
around 50%.
*I have tested using both the runtime and full versions of Access in
the VPC (no difference)
-I have tested on my development machine using combinations of the
RUNTIME switch, and the front end as an .mdb and .mde (the report
always runs fine)
Environment:
Windows XP is running on all machines
Split application
Front end: Access 2002-2003 file format (.mde)
Back end: Access 2000 file format (replicated)
Access 2003 runtime
There is no network involved. Both the front end and back end are on
the same physical machine.
Any help is greatly appreciated.
Thanks.