Microsoft Access "No More Memory"

%3CLINGO-SUB%20id%3D%22lingo-sub-1687285%22%20slang%3D%22en-US%22%3EMicrosoft%20Access%20%22No%20More%20Memory%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687285%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20my%20Access%20365%20to%20have%20all%20the%20Names%20of%20All%20my%20Music%2C%20CDs%2C%20DVDs%20and%20so%20on.%20But%20now%20it%20tells%20me%20%22No%20more%20Memory%22%20It%20is%20on%2089.9%20MB.%20Can%20I%20Extend%20th%20Capacity%20or%20how%20can%20I%20get%20Access%20to%20Access%20again%3F%20I%20had%20the%20Problem%20some%20Months%20ago%2C%20but%20at%20that%20Time%20suddenly%20not%20a%20Problem%20more.%20What%20can%20I%20do%3F%20Hope%20to%20get%20an%20Answer%20I%20can%20use.%20Ole%2C%20Odense%2C%20Denmark.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1687285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1687466%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Access%20%22No%20More%20Memory%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687466%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F799746%22%20target%3D%22_blank%22%3E%40OleRJ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20the%20structure%20of%20your%20database%2C%20but%20when%20you%20have%20all%20your%20Music%20and%20DVD's%20in%20one%20(big)%20table%2C%20maybe%20it's%20possible%20to%20split%20it%20in%20separate%20(smaller)%20tables%20and%20see%20if%20that%20makes%20a%20difference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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? I had the Problem some Months ago, but at that Time suddenly not a Problem more. What can I do? Hope to get an Answer I can use. Ole, Odense, Denmark.

5 Replies
Highlighted

@OleRJ 

I don't know the structure of your database, but when you have all your Music and DVD's in one (big) table, maybe it's possible to split it in separate (smaller) tables and see if that makes a difference.

 

Highlighted

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

 

Highlighted

@George Hepworth 

OleRJ_0-1600594685040.pngOleRJ_1-1600594711936.png

89.9 MB is for the Whole Access File.

Highlighted

@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? 

@OleRJ 

1st Perform Compact & Repair

2nd if doesn't get your issues resolved the try to Decompile your application

3rd if nothing of the above works then create  a new blank database and copy everything to it...it should get things resolved.

If again you hit  a brick wall ,there is a small chance a background operation is blocking Access so take a good look on what you have running and try to disable them to see if this helps.