Access Running Slow. Help?

[alyon]

Rawb
1. Yes, everyone has their own copy of the frontend.


2. I compact & repair both frontends and backends daily.
3. The database is on the network. You do not need to connect to the internet first.
4. I don't believe we are using UAC, we don't have to log in first.
5. How do I compile the code? That probably definitely needs to be done. I followed the steps on one of the links listed with suggestions, and when I hit the debug, compile, it comes up with an error.

[Rawb]

I have a database where one of the Queries takes a full 20-30 seconds to run. I ended up just dumping the results into a Temporary Table and then pointing everything that relied on that Query to that Table. You may have something similar.

The only other thing I can think of is that it's an issue on the individual computers and not something directly related to Access (like a virus)...

If you can reproduce the slowdowns on a computer with a full version of Access, try breaking the Code (CTRL+BREAK) when you hit one to see what Code it's working through (if any). That should at least help narrow things down a bit.