Another Access System Resources Exceeded Question
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
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
Last Comment
ASKER
Thanks to you both - puppydogbuddy - I read the article and I have a 2TB drive and a separate GPU already so that shouldn't be an issue and I'm running a Core i5. That should be able to power through pretty much all that I throw at it. Especially since this was all running on a 4 year old dual core processor.
aikimark - not sure about the Access zone you are talking about.
This is frustrating I've read so many things online that relate nothing to what I'm experiencing. I just don't understand why I would have more problems now with the "latest and greatest" than I did with the old ghetto machine I had.
aikimark - not sure about the Access zone you are talking about.
This is frustrating I've read so many things online that relate nothing to what I'm experiencing. I just don't understand why I would have more problems now with the "latest and greatest" than I did with the old ghetto machine I had.
How complicated is your database?
Are you using linked tables?
I assume you used compact and repair.
There are similar issues. This one applies to access 2007.
http://support.microsoft.com/kb/918814
But since it was fine using 2007, is there a way in 2010 to save the database in 2007 format? If so, does it work as expected?
Can you reproduce the issue, by creating a database in 2010 and import objects from the old database?
Are you using linked tables?
I assume you used compact and repair.
There are similar issues. This one applies to access 2007.
http://support.microsoft.com/kb/918814
But since it was fine using 2007, is there a way in 2010 to save the database in 2007 format? If so, does it work as expected?
Can you reproduce the issue, by creating a database in 2010 and import objects from the old database?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Bitsqueuser:
My database is only 749 meg right now -though I'm sure that grows during calculations, etc - but I'm not sure at to 2GB. We link to an Oracle DB but the queries and make tables are pretty simple overall (designed that way to minimize time, etc when I first created this). If I were using this without the linked tables I think I could use the SQL back-end you recommend but I think I'm out of luck there. I guess I'll just have to go back to the drawing board and find better ways to re-create my files to fix this.
My overall impression with Office 2010 has not been the greatest - though I'm forcing myself to keep using it! Seems the newer versions require more effort to do a lot of the simple tasks I used to once be able to do in previous versions of Office like 2003.
My database is only 749 meg right now -though I'm sure that grows during calculations, etc - but I'm not sure at to 2GB. We link to an Oracle DB but the queries and make tables are pretty simple overall (designed that way to minimize time, etc when I first created this). If I were using this without the linked tables I think I could use the SQL back-end you recommend but I think I'm out of luck there. I guess I'll just have to go back to the drawing board and find better ways to re-create my files to fix this.
My overall impression with Office 2010 has not been the greatest - though I'm forcing myself to keep using it! Seems the newer versions require more effort to do a lot of the simple tasks I used to once be able to do in previous versions of Office like 2003.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
two additonal hardware requirements for 2010 vs 2007;
1. A separate graphics processor
2. Additonal disk space