REPORT FREEZING

  • Thread starter Thread starter gmenon100 via AccessMonster.com
  • Start date Start date
G

gmenon100 via AccessMonster.com

I have an access project database with sql backend. When I run a preview of a
report with filters, the system freezes and displays " formatting page press
Ctr+Break to stop". I have to force access to shutdown and restart, but this
problem does not disappear.

Please help!!!!
 
You probably have code in the OnFormat event of the report. The can cause
the report to format, read, format again after your code runs, read, etc. in
what might seem like an endless loop. Try adding a wrapper to your code
like this:

If FormatCount = 1 Then
..... Your code here

End if
 
I am having similar problems. I have access front end with Sql back end. I
am generating a report with a query as the record source. The query of the
report when previewed opens in less than one second, however the report
freezes and will open after 40 minutes or more.

The report is based off of an inventory table with SKU, UPC, Description,
and CustPart. All of the data displays correctly in the query result and I
can add any of the fields to the report without a problem, until I add the
CustPart, then the report locks up. The CustPart is an nvarchar(20).

Any suggestions? gmenon100 have you tried opening your query?
 
After playing around with the report, I found that if I take the SQL
statement from the query and paste that into the record source the report
opens in 1-2 seconds vs the long lockup. I am not sure why this would be the
case because I thought the advantage of having a saved query is that the
query saves the best execution path.

gmenon100 you might want to try this, if your problem is like mine.

Regards,
Dave
 
I am out of office and will try and reply. Thanks for your response. Higly
appreciated.
You probably have code in the OnFormat event of the report. The can cause
the report to format, read, format again after your code runs, read, etc. in
what might seem like an endless loop. Try adding a wrapper to your code
like this:

If FormatCount = 1 Then
.... Your code here

End if
I have an access project database with sql backend. When I run a preview of
a
Click to expand...
[quoted text clipped - 5 lines]
Please help!!!!
Click to expand...
Click to expand...
 
With the query, I do not have this problem, but my report is based on a
filter applied to the query and it freezes. I will try your suggestion and
check if it improves the performance. Thank you for your response
 
Back
Top