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.