1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access 2010 "System Resource Exceeded"

Discussion in 'Business Applications' started by XpL0d3r, Dec 20, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. XpL0d3r

    XpL0d3r Thread Starter

    Joined:
    May 20, 2005
    Messages:
    85
    Hi All,

    Having an issue with an Access database using an ODBC connection. This issue is only for ONE computer -- all other computers that connect to this database work fine.

    When running a query in Access 2010, after a few minutes the user gets a "system resource exceeded" error. The ODBC connection is set up properly, and have mirror settings from another user where this is working properly.

    Tested the memory on the computer (it's less than two months old anyways), and has tested fine. There is a hotfix that was released in October (http://support.microsoft.com/kb/2726928) in regards to this issue, but even after installing and making the required registry change to "activate" the hotfix -- the issue is still occuring.

    Unfortunately I'm not the person who created this database, and I don't know much about it. I'm just the IT guy who setup her ODBC connection. Checked the ODBC driver and it is the same version as all other users. As this database works fine with every user except for one, I don't believe there is any need to modify the database.

    The computer that the user is working on is a Dell Optiplex 3010, Windows 7 Enterprise x64 (our standard OS image).

    Any thoughts or advice on this?

    Thanks
     
  2. MScott821

    MScott821

    Joined:
    Dec 17, 2012
    Messages:
    19
    Where is the Access db living? Out on the network somewhere?

    What are you connecting with via the ODBC? - Access locally, Excel,...?

    Is the "receiving" app on her end the same version and patch level as the other systems?

    How much data are you dealing with here and what exactly is the application/use of the data?
     
  3. XpL0d3r

    XpL0d3r Thread Starter

    Joined:
    May 20, 2005
    Messages:
    85
    The database is on our server, though even if copied locally the same error occurs.

    Connecting to another Access database on the network. The app on her end is the same version / patch as the others.

    The database it's connecting to is ~180MB, and is being used to keep track of invoices from our ERP system.

    Thanks for the quick response. I also noticed that every 1/15 tries or so it actually works -- but when I try to use a filter on the generated data I get an error on requery, 3420.
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    She doesn't by any chance have a 64bit system running 64bit MS Office does she?
    As I have had issues with setup and split databases. I had to move some tables to the Front Ends to overcome "Connectivity" and Resource issues.
     
  5. XpL0d3r

    XpL0d3r Thread Starter

    Joined:
    May 20, 2005
    Messages:
    85
    32bit Office :/
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    What kind of Data Structure does the database have?
    Can you post a Screen Print of the Table Relationships?
     
  7. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Its a design issue not a memory issue. too many queries and or to many joins in one query. I run into it occasionally you have to break into steps. I have one situation where If I'm quering for 1000 records it works, over that it gets the System Resource Error. I have to make a table (removing one of the table joins) then append/update the rest of the data I need in the next step.

    If this is working on one machine and not the other its luck (technically speaking!) and I have seen that scenerio also.
     
  8. XpL0d3r

    XpL0d3r Thread Starter

    Joined:
    May 20, 2005
    Messages:
    85
    5 users use this database, and it worked before on each computer until one user got a new one. On her new computer the error happens. Installing Windows XP mode and Access 2010 from there to see if it works...
     
  9. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    I'm sticking with my statement about design. Your right on the edge of having to many joins, columns or something.
    Good luck though! You might be able to sneak by. I saw no difference between OS when I was fighting this. I suspect others will eventually have the same problem as the DB grows.

    Being ODBC connection guy does limit your options but after this your going to have to recommend they redesign the offending query. OBP's suggestion to make a 'front end' might help going forward. They can make a front end for the person having the problem and not effect the others.
     
  10. XpL0d3r

    XpL0d3r Thread Starter

    Joined:
    May 20, 2005
    Messages:
    85
    I don't doubt that it's a design issue by any means, but at least at this time restructuring is not really an option unfortunately. Installed Windows XP mode and it's working OK... the only downside is that I had to join the VM to the domain as well as the backend database is on the server. I don't care.. it works. lol.

    Thanks for the help!
     
  11. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    If it works ..It can't be wrong!
     
  12. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1081721

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice