Very Slow Reports In Access 2007

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alinagoo
    New Member
    • Apr 2010
    • 53

    #1

    Very Slow Reports In Access 2007

    Who knows why reports in Access2007 are so slow?
    My application has some queries that are the base of many Reports and they run very quickly! But when i run relevant report it takes long time to show information!
    What is the problem?
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Do any of your queries contain memo fields?

    I have discovered in the past that memo fields can slow report generation considerably.

    Comment

    • alinagoo
      New Member
      • Apr 2010
      • 53

      #3
      Thanks you are right!
      When i changed memo type to text type,problem eliminated!
      BYE

      Comment

      Working...