英文:
MS Access: There isn't enough memory to perform this operation (Reports)
问题
以下是翻译好的内容：
有一些帖子与相同主题，但我在我的MS Access应用程序（与SQL Server数据库一起使用）中的行为与其他人不同。
在我的PC上（Win10 Pro，8GB DDR4 2GB可用），以及大多数客户的PC上，它都运行正常。但在两台客户的机器上，报告甚至无法以设计模式打开（所有报告，仅报告 - 表格、查询都正常）。所有报告都非常简单，最多只有一个子报告。
因此，当客户想要打开接收到的报告时，他们会收到消息框：
"没有足够的内存来执行此操作。关闭不需要的程序，然后重试操作。"
他们两人都有足够的RAM。第一个人有12GB DDR3（剩余7.5GB），另一个人有8GB DDR3（剩余3.5GB）。两者都在使用Windows 10 Pro和Office 365。
我尝试过：
- 增加页面文件（虚拟内存）
- 将“图形性能首选项”设置为“节能”以供MS Access使用
- 清理磁盘
- 重新安装MS Office
英文:
There are some of the posts with the same subject but the behavior I have with my MS Access application (with SQL Server database) is different than others.
On my PC (Win10 Pro, 8GB DDR4 2GB free), and the majority of clients 'PCs, it works perfectly fine. But on two of the clients' machines, reports couldn't be open even in Design mode (all reports, and just the reports - forms, queries are fine). All of the reports are very simple, with up to one subreport.
So, when the client wants to open a report he received msg box:
"There isn't enough memory to perform this operation. Close unneeded programs and try the operation again."
Both of them have enough RAM. The first one has 12GB DDR3 (7,5 GB free), and another one has 8GB DDR3 (3,5 GB free). Both are using Windows 10 Pro and Office 365.
I tried to:
- Increase Paging File (Virtual Memory)
- Setting "Graphics performance preference" to "Power saving" for MS Access
- Disc Clean-Up
- Reinstall MS Office
答案1
得分: 0
It happened also to us and with Microsoft we are trying to sort out the reason (that in our case is connected to the update 2305 build 16501.20196). Also here there is a new post about link If yes, contact Microsoft through the feedback function inside Access (so maybe with more cases they are able to find what it's in common).
英文:
Did it happen after the Office 365 update 2305?
It happened also to us and with Microsoft we are trying to sort out the reason (that in our case is connected to the update 2305 build 16501.20196).
Also here there is a new post about https://techcommunity.microsoft.com/t5/access-blog/access-releases-14-issue-fixes-in-version-2305-released-june-1st/bc-p/3841797
If yes, contact Microsoft through the feedback function inside Access (so maybe with more cases they are able to find what it's in common).
答案2
得分: 0
在我的应用程序中，AutoExec 宏负责设置应用程序选项并启动登录表单。通常，在登录之后（考虑到它使用 SQL Server 后端，链接表格/透传查询），我会在事后测试报告是否正常运行。
由于某种原因，这个问题在版本 16501.20196 上一直会重复出现，但在 16327.XXXXX 上则没有体现出来。
我找到了一个解决方法，你可以检查它是否适用于你：在打开文件时按住 Shift 键，然后选择要打开的报告（甚至可以专门为此测试创建一个空白报告）。在登录或运行任何代码之前打开并关闭此报告。
按照这个步骤，登录后，报告应该按预期工作。
作为临时解决方案，我在我的 AutoExec 宏中将打开/关闭报告的打印预览作为初始操作。这似乎暂时解决了问题，至少在微软解决根本原因之前，请将其视为一种权宜之计，而不是最终解决方案。
英文:
In my application, an AutoExec macro is responsible for setting application options and initiating the login form. Usually, upon login (considering it uses a SQL Server backend, linking tables/pass-through queries), I would test if the reports were operational after the fact.
For some reason, the problem is consistently repeatable on versions 16501.20196, but doesn't manifest on 16327.XXXXX.
I found a workaround for this issue, here's how you can check if it will work for you: Hold the shift key while opening the file and select a report of your choice to open (you could even create a blank report solely for this testing purpose). Open and close this report prior to logging in or running any code.
Following this procedure, upon login, the reports should function as expected.
As a temporary solution, I've incorporated the open/close report in print preview as the initial action in my AutoExec macro. This seems to alleviate the issue for now, at least until Microsoft addresses the root cause.
Please consider this a workaround rather than a definitive solution.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论