Avatar of UTAT1
UTAT1
Flag for United States of America asked on

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
Microsoft ApplicationsMicrosoft Legacy OSOffice ProductivityMicrosoft Access

Avatar of undefined
Last Comment
Sachin Parab

8/22/2022 - Mon
puppydogbuddy

See this link:  http://blogs.technet.com/b/office2010/archive/2010/01/22/office-2010-system-requirements.aspx

two additonal hardware requirements for 2010 vs 2007;
    1. A separate graphics processor
     2. Additonal disk space
UTAT1

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.

Hamed Nasr

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?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
SOLUTION
Bitsqueezer

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
UTAT1

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.
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Sachin Parab

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.