Access 2016 accde "DoCmd.OutputTo acOutputReport, , acFormatPDF..." crashes after 10 minutes

Hi Alex,

Thank you for your reply,

For me SSRS sounds like "Let's go Goran sit back and spend another few months in changing and testing the application, explain to hundreds of users why they can't have their reports the way they used to, update all of them successfully, change user manuals, website, legal agreements and so and so..". If Microsoft want to cover the expenses and loss I would consider the other solution. 

Otherwise, I am asking Microsoft to give us at least explanation what is going on...!!!

Any idea how to solve the issue would be also greatly appreciated...

Thank you in advance

Thank you for your reply Goran.  I have not seen any response from Microsoft.  I definitely would like the problem fixed, but sort of stopped looking for a solution since I recently began using SSRS (Sql Server Reporting Services) to generate pdf's of reports for those few cases where the "wait 8 minutes and crash" scenario is likely to take place.

This problem persist since Office 2016/Access 2016 has been deployed

Create PDF or XPS in Access 2016 (.accdb) is no problem.

Create PDF or XPS  from (.accde or .accdr) crashes after 8 minutes.

Command: DoCmd.OutputTo  acOutputReport, "myReport", acFormatPDF ...

At first the DoCmd.OutputTo method works fine.

But if you wait more then 8 minutes and then try to run DoCmd.OutputTo again, Access crashes!

Anyone from Microsoft to respond?

Thank you successcontrol.

So, let me see if I understand correctly.  In the first case, the ten minute idle is too much, provided the extension is .accdr, which extension means that the access runtime engine is employed, even though you have the full version of access2016 installed.

In the second case,  repeated short term idling (15 seconds) does not prevent the pdf from being stored.  This is so no matter the extension, I gather.   Very good.  [Too bad we cannot rely on our users to never allow the app to go idle!!!]

Though I do not name my access file with an .accdr extension, I still experience the problem.  My file is named with an accdb extension.  However, since my application is launched from the command line as follows:

START "" "C:\Program Files (x86)\Microsoft Office\Office16\MSACCESS.EXE" /runtime "C:\Temp\FOO-APPS.accdb"

I am effectively causing the access runtime to kick in, I figure -- please see my /runtime flag.

This is good work you are doing. 

Thank you for contributing your time and insight.

I did some additional testing;

Version: Access 2016 - 16.0.6769.2017

1. create a simple Report
2. create a Form - set Timer Intervall 600000
3. Set Event on Timer:

Private Sub Form_Timer()

Dim strFile As String

strFile = "C:\Temp\A2016PDF-test\PDFs" & Format(Now, "hhmmss") & ".pdf"

DoCmd.OutputTo acOutputReport, "Areport", acFormatPDF, strFile, True, , , acExportQualityPrint

End Sub

Save as test.accdb

and compile as test.accde

open test.accdb

> after 10 minutes PDF is created

open test.accde

> after 10 minutes PDF is created

rename test.accdb to test.accdr

> after 10 minutes Access crashes

rename test.accde to test.accdr

> after 10 minutes Access crashes

Do the same with timerintervall  15000

> every 15 seconds a PDF is created without Problems

So the Problem seems to be, if Access idles for several minutes.