MS Access:没有足够的内存来执行此操作 [英] MS Access: There isn't enough memory to perform this operation

问题描述

我在具有4GB RAM的双核计算机上使用Access 2003，运行Windows XP(Service Pack 3)[5.1.2600]

I'm using Access 2003 on a duo-core machine with 4GB of RAM, running Windows XP (Service Pack 3) [5.1.2600]

周期性地，我收到一条错误消息:没有足够的内存来执行此操作.请关闭不需要的程序，然后重试该操作."

Periodically, I get an error msg "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again."

检查任务管理器表明有足够的可用内存.关闭其他打开的程序没有任何作用.

A check of Task Manager indicates that there is plenty of free memory. Closing other open programs makes no difference.

这是偶尔发生的，并且发生在不同的情况下:有时在保存表单设计或VBA代码更改时，有时在打开并使用多个表单时.

This happens sporadically, and under different circumstances: sometimes whilst saving Form design or VBA code changes, sometimes when several Forms are open and in use.

如果尝试保存设计更改，并且发生此错误，则Access对象已损坏，无法恢复.

If attempting to save design changes, and this error occurs, the Access objects are corrupted and can't be recovered.

任何可能导致此问题的建议都将受到欢迎.

Any suggestions on what might be causing this would be very welcome.

MTIA

推荐答案

据我所知，它很可能是损坏的表格或报告，我创建了一个新的mdb，并且仅导入了表(附加)，查询，脚本(仅一个)，模块和菜单.然后，我使用LoadFromText通过函数导入Forms和Reports，然后进行通常的反编译/编译和压缩/修复等操作.

As I know that it's either forms or reports that most likely get corrupted, I created a new mdb, and only imported tables (attached), queries, scripts (one only), modules and menus. Then I used LoadFromText to import Forms and Reports via a function, and then did the usual decompile/compile and compact/repair etc.

到目前为止，接触木头，几天来我再没有发生过崩溃，所以我可能会坚持使用这种恢复方法.

So far, touch wood, I haven't had another crash in some days, so I'll probably stick with this recovery method.

非常感谢大家的建议.

这篇关于MS Access:没有足够的内存来执行此操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！