access 2003 running very slow

[complexx]

I have access 2003 installed on two different machines. One machine was built 6 months ago with the best hardware available. The other was an older slow IBM.

For some reason, I am experiencing what appears to be some serious time delay (talking in the range of seconds, sometimes tens of seconds) when building a report that has a subreport in it on the fast machine. Yet when I load the exact same database on the slow machine, the report opens instantly.

Any ideas? I'm lost.

 

[Fuga]

Sometimes a db gets corrupted. Try repairing and compacting.

Also check joins etc in queries so that they´re still there. (They dissapeared for me once. Queries took forever.)

Fuga.

 

[The_Doc_Man]

Add to that the possibility of differences in the "references" because that is a registry thing. It is possible that you are getting a mismatch between versions of a .DLL file, one of which is faster than the other.

Also, old machine doesn't always mean slow machine - if it has enough memory that you don't have to swap or page out the data segments. I'll take a slightly older machine that is buff with memory over and underconfigured speed demon any day. CPUs don't rule the roost. Memory does. If you are swapping 'cause you don't have enough memory, you never get to see your CPU in action.

If you can find the performance monitors on the two machines, see if the newer machine is doing more swapping. If so, you hit a memory barrier.

 

[complexx]

Thanks for the advice. The data I'm working with is very basic, no calculations involved. I'll look into the information you guys provided me with.

I don't think memory is the issue, but hey, you never know.