Forum Discussion

gnarlesv's avatar
gnarlesv
Copper Contributor
Oct 16, 2020

system resources exceeded error

i have been using access for many, many years and am using a current office 365 version (2009) with windows fully up to date on an lenovo thinkpad with 32gb ram etc. while i had sporadically gotten t...
access
NevilleA's avatar
NevilleA
Copper Contributor
Oct 17, 2020

gnarlesv This is the same issue I have. MS will not help me. My system was upgraded yesterday and since then my Access code is failing due to this error. I thought my table was corrupted. After rebuilding it and removing all bar 100,000 records, it still does it. There is something dreadfully wrong with probably Win 10 as this problem only appeared rarely in Access since the W10 update. My access table which is called when the system resources exceeded error occurs had 386,000 records before W10 update, but after W10 update, it now stops. As I said, I culled it back to 100,000 records and for some code, it runs, but for others it now stops with that error. The program DOES NOT WORK, and MS does not want to help. I support your complaint.

 

 

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Oct 17, 2020

NevilleA 

 

I'll bring this problem to the attention of the MS Access team to see if they are aware of it and if there is a potential fix to address it.

 

 

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Oct 17, 2020

    George_Hepworth 

     

    This is a known problem but up until recently, it's been unresolved. However, "... there is a fix for this in version 2010, which is currently available for Office Insders, and will be in Current Channel at the end of this month.

    So if you know of instances where this is happening, please try version 2010 if you can to see if it resolves the issue."

     

    George

    • Zack_269's avatar
      Zack_269
      Copper Contributor
      Oct 27, 2020

      George_Hepworth Do you have a source link for the known issue status and upcoming Current Channel fix?  We have had some success changing processor affinity in the past, but are now seeing these system resources exceeded errors frequently regardless of our affinity settings.  (A365, version 2008)  I don't see this issue mentioned in the beta or current (preview) channel https://docs.microsoft.com/en-us/officeupdates/update-history-beta-channel.  

       

      Thanks!

    • gnarlesv's avatar
      gnarlesv
      Copper Contributor
      Oct 19, 2020

      George_Hepworth , Thanks George, I am re-assured that there might be a solution to this but do I need access to the office insiders channel to fix this?

    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor
      Oct 17, 2020

      George_Hepworth 

       

      Try this :

       

      Start.exe /affinity 1 [path-to]MSACCESS.EXE [path-to-your-db]

      • NevilleA's avatar
        NevilleA
        Copper Contributor
        Nov 03, 2020

        George_Hepworth hello, George.
        Is this matter being looked into at MS to your knowledge?  
        First time user, and I don’t know the procedure.

        This is an obvious problem but I don’t know if this forum is just a discussion that is trying to find work arounds rather than the supplier dealing with the problem. 

        If it is just a forum for solutions, do you know how one would tell MS about this?

         

        My contacts with MS online chat and by phone have been to their staff who in essence told me they don’t know the answer as Access is a specialist product, and I have to pay MS a fee to have it investigated. Unsatisfactory. 

        Today, after splitting my archive table and successfully using the smaller table of more current data, today I turned to access the larger second table in a query, and it failed due to system resources exceeded. MS Access is not functional any longer. To anyone who reads this post, this is not a trivial complaint, but it goes to the core failure of MS to be able to handle data in its application that it has always been able to over the last 20 years.

         

        Even though this a MS forum, does any reader know of a similar application to Access that I can buy as Access is now not usable.

         

        thanks

        Neville

Resources