MS Access "Can't complete the Output operation"

Anonymous

I have an Access DB which has a number of reports that can be exported - mostly in .xls format. Starting the last few days, attempting to export the reports for some users results in Runtime Error 2587 - "Can't complete the output operation". This only happens with .xls. All other export formats work without issue - .pdf, .rtf, .txt. I have tried performing exports directly through the ribbon to isolate and ensure there's no syntax or similar issue with my VB code. When attempting to export through the ribbon, the error message still says "Can't complete the output operation". Again, I can export these same reports to all the other available formats from the ribbon with no issue. It's just excel causing the issue.

I cannot replicate this issue on my system which makes troubleshooting difficult. Based on the limited similar issue's I've found posted I have had the end users with this issue attempt running a repair on Office 365 and rebooting their systems with no success. I am not a system admin so my access is limited and am currently waiting on assistance from that department.

Some users are running Win 10, some Win 11. All users have the same Surface pro. All users have Office 365 installed from the same package. I've had users with this issue send me their .mdb to try on my system and the issue goes away - further indicating this is an issue with the particular devices, and not with the database itself.

Logically speaking, it sounds to me like an issue with Office but this is a little above me so looking for some guidance on how I may be able to troubleshoot such an issue, especially being that I can only attempt fixes remotely on other users' systems.

Thank you!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

If you are using Office 365 Current Channel, which is Version 2206, there is an update available, which you can get by choosing File/Account/Office Updates/Update Now. This should take you to Build 15330.20264.

Can anyone who is hitting this problem update to this version, and let us know if you are still seeing a problem with import/export?

Shane Groff

Access Engineering

0 comments

138 additional answers

Anonymous

2022-07-20T07:47:19+00:00
Hi Shane,

My customer is on Monthly Enterprise Channel (for safety, so we thought) and has Version 2205 (Build 15225.20356) and hits this error 2587 on the following code, which is building up text to insert into a long Word document.
```
    DoCmd.OutputTo ObjectType:=acOutputReport, \_ 

        objectname:=rptQuotePriceSummary.Name, \_ 

        outputformat:=acFormatTXT, \_ 

        outputfile:=CurrentProject.Path & "\PriceSummary.html", \_ 

        autostart:=False
```
I see from your reply to someone else on the Monthly Enterprise Channel that there is no fix for us yet. Do you know how long that will be, please? It is Wednesday here in the UK. Will it be today, tomorrow, next week? Am just trying to work out whether it worth getting their IT department to change the update channel.
Was this answer helpful?

0 comments No comments
Anonymous

2022-07-20T05:15:36+00:00

Hi Shane,

I have the following version, I am having same issue that the access can't export excel file. is there anything I need to do to fix the issue? seems like the 2022, build 14931.20604 is the most updated version for me. thanks

This page: Error when trying to open an ACCDE/MDE file created in a different version of Access (microsoft.com)

Will list the update information for each channel as it becomes available. The update for Semi-Annual Channel Version 2202 is not yet available.
Was this answer helpful?

0 comments No comments
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more
Anonymous

2022-07-20T01:05:04+00:00

If you are using Office 365 Current Channel, which is Version 2206, there is an update available, which you can get by choosing File/Account/Office Updates/Update Now. This should take you to Build 15330.20264.

Can anyone who is hitting this problem update to this version, and let us know if you are still seeing a problem with import/export?

Shane Groff

Access Engineering

I'm not 100% sure I have the exact same issue as this post, but is similar, just recently broke in Build 15330.20230, and is not solved by Build 15330.20264.

Please see here for my details, the 5th post down on Page 2.

Error 3125 after many years working OK...?

You'll see that I was directed to this thread from that one.
Was this answer helpful?

0 comments No comments