开发者

MS Access: Can't complete the Output operation

开发者 https://www.devze.com 2023-04-12 21:42 出处:网络
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 applicati

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 applicati开发者_StackOverflow中文版on 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.


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 the ACCWIZ directory to the same directory as MSACCESS.EXE

You 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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号