Slow Editing Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access report that was created some time ago, which is based on a
query. Immediately after I change any control in the report, the report
freezes for about 20-30 seconds and then returns to control to me. Even
simple things like lines changes to lines sizes, this happens. The other
reports in the datbase appear to be fine. I have compacted the database--no
change. Frustration is setting in :-)

Any help please? thanks
 
First thing would be to make sure the Name AutoCorrect boxes are unchecked
under:
Tools | Options | General | Name AutoCorrect
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
Explanation of why:
http://allenbrowne.com/bug-03.html

If the report is based on a crosstab query, you could solve the issue by
specifying all the possible values in the Column Headings property of the
query. That way, Access does not have to run the query to completion before
it can determine the fields for the report.

Other general suggestions for performance issues in Access:
http://www.granite.ab.ca/access/performancefaq.htm
 
Thank you Allen...

The crosstab query appears to have been rather complex. Defining the column
headings solved my problem.
 
Back
Top