Forum Discussion

OleRJ's avatar
OleRJ
Copper Contributor
Sep 19, 2020

Microsoft Access "No More Memory"

I use my Access 365 to have all the Names of All my Music, CDs, DVDs and so on. But now it tells me "No more Memory" It is on 89.9 MB. Can I Extend th Capacity or how can I get Access to Access again...
2010
access
office 365
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Sep 19, 2020

OleRJ Can you be more precise about exactly when and how the error "No more memory" is raised?

Unfortunately, that can be related to more than one possible problem, so diagnosing it requires more details. Is this, for example, related to RAM? I suspect it is, but let's be sure we're on the same page.

 

"It is on 89.9 MB" is a bit ambiguous. Is that the size of your accdb file itself? If so, that's really quite small relatively speaking. 

 

  • OleRJ's avatar
    OleRJ
    Copper Contributor
    Sep 20, 2020

    George_Hepworth 

    89.9 MB is for the Whole Access File.

    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor
      Sep 20, 2020

      OleRJ Okay, then.

       

      We can eliminate the file size as an issue. 89.9 MB is VERY small for a production Access relational database application file (accdb).

       

      This problem appears, therefore, to be related to RAM. How much do you have installed?

      While it is hard to diagnose such things from a distance, we know that certain kinds of operations can consume all available resources. When does this happen? For example, does it occur when running an update, append or delete query? 

Resources