RE: Report is Running Very Slow

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---

--
RyGuy


"ryguy7272" wrote:

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--
--
RyGuy
.

Relevant Pages

  • Report is Running Very Slow
    ... I created a Report that is linked to a Crosstab Query. ... as it relies on data from 6 tables and but it only includes 8 ... Anyway, the Query seems to run fine, but the Report that the Query ... Everything else seems to run at reasonable speeds. ...
    (microsoft.public.access.reports)
  • Word Document pieces in Access Reports print Larger than they are in word
    ... We have been embedding Pieces of Word Documents into ... We currently are running Access ... This is the first report we are creating since we ... dynamic data inbetween based on query results. ...
    (microsoft.public.access.reports)
  • How to suppress printing a value in a field depending on the value in another field.
    ... I have a report, based on a query, in which for each record I want to ... I'm running Access 2000 on XP Professional. ... Julian Allsopp ...
    (microsoft.public.access.reports)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)