I suggest you ...

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

Create PDF in accdb is no problem.

Create PDF in accde or accdr crashes after 10 minutes or sporadic
only with Access 2016 (with 2007, 2010, 2013 everything is fine)

22 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    ChristianChristian shared this idea  ·   ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • ChristianChristian commented  · 

        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.

      • RobertRobert commented  · 

        Same problem for me (full app or runtime)

      Feedback and Knowledge Base