Intermittent Error 2501: The Open Report Action was canceled
Posted on 2012-03-19
I am getting Error 2501 in a very intermittent and inconsistent fashion. It typically only occurs on a couple of windows 7 clients but other identical systems do not generate the error. Those systems only seem to have the problem at certain times or days.
The following DoCmd.OutputTo line of code is the "problem":
MyFileName = "Full Exam - " & Format(Now, "mm-dd-yyyy hh-mm-ss") & ".pdf"
DoCmd.OutputTo acOutputReport, "rptMyReport", acFormatPDF, FilePath & MyFileName, 0
DoCmd.Close acForm, "frmAnotherForm"
The issue will go away and then return another day. Sometimes reinstalling the runtime seems to make it better others not.
I am wondering if it is a timeout issue with the network / server system although I have never seen it happen on any of the clients running XP Pro. Perhaps it is the Windows 7 devices are running so fast that the server doesn't have time to finish before the code continues. ??? Obviously I have no clue.
Anyway there are a lot of posts about this but none seem to have a solution.
I am running Access 2007 front end with MS SQL Server 2008 backend on a LAN with a brand new server with lots of capacity.