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
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.

NevilleA's avatar
NevilleA
Copper Contributor
Dec 30, 2020

rtdavis3 Thanks. It’s good you found a fix. I don’t use OneDrive however, so my error persists.

  • LorinH's avatar
    LorinH
    Copper Contributor
    Jan 12, 2021

    NevilleA 

     

    I found a workaround. You need to to run the program as an administrator which, I speculate, frees up resources and the error stops.

     

    Here are the steps to run the program as an administrator.  Start by copying your database/file location:

     

    1. Right-Click on the desktop -> New -> Shortcut
    2. Paste in your file location.
    3. Name shortcut
    4. Right-Click on the new shortcut -> Properties
    5. Click Advanced
    6. Check “Run as Administrator”
    7. Apply

    NOTE: When I first start the program I get "system resources exceeded". I close the program and re-open and it works fine. Not sure why I have to open, then re-close, for it to work.

Resources