Report Hangs on WinNT 4.0 Machine - 100% CPU Usage

  • Thread starter Thread starter Barb T
  • Start date Start date
B

Barb T

I have a very complex report (multiple sub-reports, lots
of formatting, lots of formatting functions called by the
report at runtime, etc.) The report resides within a
Microsoft Access MDB that is called by a VB6 application.

The report prints just fine on WinXP and Win2K
computers. I also have two versions of the Access
database, one is Access 2000 and the other is Access
2002, both of which run fine on the WinXP and Win2K
computers. However, when attempting to print the report
from the VB6 app on the WinNT 4.0 machine, the report
hangs with CPU usage going to 100% forever. I can print
the report directly from the MDB file, and I can also do
this while I have the VB6 app open.

I've downloaded the latest service packs for NT,
Office2K, and Jet4.0. My Access app is connected to a
SQL Server 2000 database via ODBC; the SQL Server ODBC
driver is dated 21-Jul-2003. I'm out of ideas and would
appreciate any assistance!
 
Barb:

1.) First, try looking at your report. You state that there are a lot of
format functions etc. These can easily cause what seems to be a hang as
Access often reformats sections repeatedly thereby running and re-running
your code. To speed that process up, open the report and subreports and in
each section where you have code in the On Format event, add wrapper code
like this:

If FormatCount = 1 Then
'Your Code here
End if

2.) On your NT box, check for the latest printer and video drivers as well.
These can impact Access' writing to the GDI subsystem which it uses to
render the report.....

3.) Make sure that you have the latest VB 6 service releases (SP 5 is
current).

HTH
 
Back
Top