Report is Running Very Slow

R

ryguy7272

I created a Report that is linked to a Crosstab Query. The Query is somewhat
complex, as it relies on data from 6 tables and but it only includes 8
columns. Anyway, the Query seems to run fine, but the Report that the Query
is built on is running extremely slow. It takes, sometimes, up to five
minutes for the Report to show the results of the Query. Is there some new
way of building Reports in Access 2007 that could cause it to run at speeds
that are basically intolerable. The same Report in Access 2003 takes a few
seconds to build. Everything else seems to run at reasonable speeds. The DB
is a little over 13MB.

Regards,
Ryan--
 
R

ryguy7272

I was running Access 2003 for a long time and I was very happy with it.
Access 2007 seems to be too slow for anything practical. I'm 'upgrading'
from 2007 to 2003.

Thanks,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report Group Footer DLookUp 0
Crosstab in a Subreport running slow...not due to dynamic headings 2
Report Running Very Slow 1
Access 2002 change report header text 0
Word 2016 opening sooo slow 0
report performance issue 4
design view changes very slow 1

Top