troubleshooting Question

Another Access System Resources Exceeded Question

Avatar of UTAT1
UTAT1Flag for United States of America asked on
Microsoft AccessOffice ProductivityMicrosoft Legacy OSMicrosoft Applications
7 Comments2 Solutions5395 ViewsLast Modified:
Hello and thanks in advance for helping with this.

I don't know if it's me or Microsoft - but I have been receiving the error in the subject a lot. I have searched through here but have not found a solution that matches my problem.

For the past year I have been working on a Wndows 7 32 bit machine and using Office 2007 (Access specifically). I recently upgraded machines to another, faster, Windows 7 computer but upgraded to Office 2010. Since then my life has been hell. Aside from just finding things in 2010 again - my queries in Access bomb much of the time with the "System Resources Exceeded" error. I'm not sure why this is happening on a new machine. I would assume Office 2010 would be able to handle anything 2007 could! This is just one issue I'm having with this - I'll bring the other up in another question.

Queries are just simple make table queries - nothing too complex or too many joins, etc.

Any help is appreciated as it's hindering my work! Please let me know if I can provide any additional info to figure this out.

Thanks!

Tony
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros