Slow Editing Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

faberk - 15 Nov 2006 15:00 GMT

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

Reply to this Message

Allen Browne - 15 Nov 2006 15:48 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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
[quoted text clipped - 5 lines]
>
> Any help please? thanks

Reply to this Message

faberk - 15 Nov 2006 19:35 GMT

Thank you Allen...

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

> First thing would be to make sure the Name AutoCorrect boxes are unchecked
> under:
[quoted text clipped - 21 lines]
> >
> > Any help please? thanks

Reply to this Message