MS Access:无法完成输出操作
我不是一位经验丰富的 VBA 程序员,并且我不喜欢使用 Access。我被要求修复 MS Access 2010 VB 应用程序中的一些错误。唯一用户之前在 32 位平台上运行该应用程序,但现在已迁移到 64 位。这导致应用程序中断。我已经取得了一些进展,但我解决的每个问题似乎都会出现。
以下代码段
DoCmd.OutputTo acOutputReport, "rptQLDExport", acFormatRTF, frm.txtDirectory.Value + "\QLD\All\QDATA.DOC"
导致运行时错误 2587: Microsoft Access 无法完成输出操作
我在网上搜索了答案,但无济于事。
我的开发环境是Windows 7 SP1(64位),应用程序在Access 2010(vba7,64位)中运行。我愿意回答问题以提供更多信息。任何建议将不胜感激。
I'm not an experienced vba programmer and working with access is not my cup of tea. I've been asked to fix some errors in an MS Access 2010 VB application. The sole user previously ran the application on a 32-bit platform but now has migrated to 64-bit. This caused the aplication to break. I have made some progress but every issue I resolve another seems to appear.
The following piece of code
DoCmd.OutputTo acOutputReport, "rptQLDExport", acFormatRTF, frm.txtDirectory.Value + "\QLD\All\QDATA.DOC"
is causing a runtime error 2587: Microsoft Access can't complete the Output operation
I have seached on the net for an answer but to no avail.
My development environment is Windows 7 SP1 (64-bit) and the application is running in Access 2010 (vba7, 64-bit). I'm willing answer questions to provide more information. Any suggestion will be appreciated.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这篇论坛帖子表明它与运行时与完整版本有关访问(或办公室)。建议的解决方案是将文件
UTILITY.ACCDA
从ACCWIZ
目录复制到与 MSACCESS.EXE 相同的目录中。在应用程序中分发该文件之前,您需要检查许可安装程序,显然。
更新:在出现故障的计算机上,复制 ProcessMonitor(来自 technet;无需安装)。过滤到您的应用程序。重复这个过程并让它失败。检查您的应用程序尝试访问的文件以及它们失败的原因。
This forum post suggests it is related to runtime versus full versions of Access (or Office). The suggested solution is to Copy the file
UTILITY.ACCDA
from theACCWIZ
directory to the same directory as MSACCESS.EXEYou would need to check licensing before distributing the file in your application installer, obviously.
Update: On a machine that fails, copy over ProcessMonitor (from technet; no install required). Filter to your application. Repeat the process and get it to fail. Examine the files that your application is trying to access and why they fail.