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
Joseph Natarajan's avatar
Joseph Natarajan
Copper Contributor
Dec 11, 2020

gnarlesv   I have been using MS Access for more than 10-15  years and this system resources exceeded error that started happening a month ago has been very frustrating. I have tried various combinations of set affinity in the start path /task manager and I am constantly getting this error even for small tables. This has to be fixed ASAP since I am sure thousands of users are currently struggling with this. Meanwhile  Just want to share with you  an alternate solution that I am using for the time being to do my data transformations. I am using   python  and a package called pandas to do my data manipulations.  and it is working fine. Once I am  done with my work inside python , I export the data to a csv file and then load to MS Access. I am a beginner in python but it is easy to learn like VBA

  • Jake104E's avatar
    Jake104E
    Copper Contributor
    Dec 12, 2020

    I have just experienced what I believe to be the same error on the Siemens WinCC application (used for making industrial user interfaces).

    The WinCC runs in a Win10 as the only application (except for what else is running on a Windows PC), but it uses a number of MS-Access-files through ODBC where these .mdb-files are registered as data sources.

    I believe the behaviour is related to Win10. I have had the same application run on Win7 for many years without any such issues.

    I can have the code trap the error "Error #-2147024882: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded" - and make a reboot of the system - which solves the problem (for a while).

    The just experienced incident is on a Windows 10 Pro, version 2004

    I believe it has also happened on a Windows 10 Pro, version 1903, but here I did not have proper logging of errors set up, so I don't know for sure.

     

    Anyway - I hope a fix for Win10 will address this soon - and then I need to find a way to install that on installations with no internet-access.

     

    In the meantime I guess, I'll make logic to perform a reboot in case this error occurs... 

    • NevilleA's avatar
      NevilleA
      Copper Contributor
      Dec 12, 2020

      Jake104E thanks. 
      I think also that W10 is the problem.

      It first started when W10 had an update on my computer, but at the same time, MS updated Office (to an Office 365 version). The W10 update was in October.

      I do not own Office 365 and a number of days later, the Office 365 version disappeared (I don’t know how, but didn’t bother to research), and my Office returned to the version.

      After the initial update, the system resources error appeared, and has remained.

      The error comes when my VB code is accessing large data tables. I closed Teams, Outlook, Excel and Word, then ran my access code, and it went through without error.

      In an another run, accessing a different larger table, the error appeared though.

      Since my access has not been changed, the problem can only be W10.

       

       

      • rtdavis3's avatar
        rtdavis3
        Copper Contributor
        Dec 28, 2020

        NevilleA This worked for me... I had MS ACCESS DB located in the area that is set to use OneDrive.  I moved the DB to an area that is not part of OneDrive and did not receive the error.

Resources