Access 2016：2004：没有内存来执行此操作。关闭不需要的程序并再次尝试操作。 [英] Access 2016: 2004: There isn't enought memory to perform this operation. Close uneeded programs and try the operation again.

问题描述

大家好，

很多I4ve都遇到以下错误：

2004：没有内存来执行此操作操作。关闭不需要的程序并再次尝试操作。

发生在Access数据库的多个位置。

当我在Access 2007上时我从未得到过这个错误，现在我在Access 2017上我得到了这个错误。

我想知道它可能来自哪里？

我使用DAO.RecordSet和我的函数和表单中的DAO.QueryDef。我是否需要一直打扫它们：

.close

SET xx = Nothing

？

或者他们是自动清理的？

我进入调试模式的大部分时间我可以要求继续...

任何帮助或理念都将受到赞赏。

谢谢。

解决方案

作为一项规则，您应该始终关闭您打开的任何Recordset。 那说你打开了多少张表格？ 另外，你最后一次运行Compact&修复

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.

解决方案

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?

这篇关于Access 2016：2004：没有内存来执行此操作。关闭不需要的程序并再次尝试操作。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！