Access 2016: 2004: There isn't enought memory to perform this operation. Close uneeded programs and try the operation again.

Question

Hi All,

AS many I4ve got the following error :

2004: There isn't enought memory to perform this operation. Close uneeded programs and try the operation again.

which occurs in several place in the Access DB.

When I was on Access 2007 I never get this error, now I'm on Access 2017 I get this error.

I wondering where it could comes from ?

I use DAO.RecordSet and DAO.QueryDef in my function and forms. Do I need to clean them all the time with :

.close

SET xx = Nothing

?

Or they are cleaned automaticaly ?

Most of the time when I enter in Debug mode I simply could ask to continue...

Any help or ide will be appreciated.

Thanks.

Answer 1

As a rule, you should always close any Recordset you open.  That said how many Forms do you have open?  Also, when was the last time you ran Compact & Repair?

---

Gina Whipp<br/> Microsoft MVP 2010-2015 (Access)<br/> Access Tips: www.access-diva.com/tips.html<br/>