Access report causes PC to lockup

R

Rick

I am having a wierd problem that I am hoping someone else has seen before.
We have an Access 97 DB front end to an SQL2k DB. When I run a particular
report on this one PC, it locks up the PC as I advance to page 5 of the 14
page report. It says "Formatting - press contro lBreak to end" at th bottom,
but the keyboard is not accessable from that point on. I have to cold boot
the computer. I used a different PC and connected to the same Access DB and
ran the same report without any problems. The only thing I noticed is that
page 5 has a #Div/0! error in one of the columns from the working PC. Could
this be causing the problem on the other PC? I have cleaned the temp files,
and ran scandisk, but the problem remains.

Any ideas?

Thank you,

Rick
 
Top