Reports Too Slow

[CCIDBMNG]

I was wondering if anyone knows a way to help make reports run faster. I am runing a report that uses a very complex query with linked tables. When I am in design view I get a 30 second lag. When I go to run, save, or open in design view it takes at least 2 minutes to open. I have 512 mb ram. Is there something else I can upgrade to make the reports run faster or should I just get more ram?

Thanks in advance.

 

[fuzzygeek]

Back_End ???

What is the backend of your DB, you said it was linked tables. Is it ACCESS or another database. If it is another database, then use a PASS THROUGH query. I took over a database once that had tables linked to ORACLE. It would take an hour or better to run some reports. I switched to a PASS THROUGH query and the report ran in 15 seconds. By using a PASS THROUGH query, the processing is done on the other db side and not in the JET Engine.

 

[CCIDBMNG]

It is linked to other access databases.

 

[fuzzygeek]

Try these

http://support.microsoft.com/default.aspx?scid=kb;en-us;209551&Product=acc

and

http://support.microsoft.com/default.aspx?scid=kb;en-us;209126&Product=acc