I just got new office machines with 64 bit XP, and now certain Access programs that I have been running for months are painfully slow, if they run at all. I've narrowed the problem down, I think.



If I have a query that selects from two INNER JOINED tables - no prob - 5 seconds to run . If I INNER JOIN third table OR LEFT OUTER JOIN a subquery - again no prob - maybe 10 - 15 seconds. If I try to add them both the program appears not run at all - (I break out after 5 minutes).

My IT guy tells me the program seems to be sending through the SQL request 1 loan at a time on certain complex joins. Can anybody tell me what might be happening?

Thanks