Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Cannot open file. Access is denied.

edited July 2015 in General
I have a few users who quite randomly get the error "Cannot open file
"C:\Users\House\AppData\Local\Temp\rspAD49.tmp". Access is denied." when
the program runs a report via Report.Print.

The report is being sent to screen.

It looks like RB is trying to put a file in the users temp directory
which is fine, but it's failing. Not all the time, but frequently enough
to be a problem.

Any ideas?

Thanks for your time
Dusten
Frontline Software Technology, Inc.

Comments

  • edited July 2015
    Hi Dustin,

    Which version of ReportBuilder and Delphi are you using? Are you able
    to recreate this issue on your machine or does this only happen on your
    clients' machines?

    As a test, try setting the PreviewFormSettings.SinglePageOnly property
    to True and retest your application.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2015
    We are using Delphi 2010, and RB 15.04.

    It does not occur on the development machine, or any machines at our
    location. It also does not occur for all of our other customers who are
    using the same version.

    I will test the PreviewFormSettings.SinglePageOnly and report back.

    Thanks!
    Dusten
  • edited July 2015
    I tested turning SinglePageOnly off, and for now the problem does seem
    to go away.

    I looked in the help file and couldn't find much a description on what
    it does. What exactly does turning SinglePageOnly off do?

    Thanks for your time
    Dusten
  • edited July 2015
    Hi Dusten,

    SinglePageOnly essentially reverts to the legacy viewer which could only
    view one page at a time.

    For the newer multi-page viewer, it is necessary to generate pages in a
    background thread in order to support continuous and multi-page viewing.
    This page information is temporarily saved to the temp directory
    during generation and it seems in some very rare cases is causing an
    issue with certain machines.

    This is a difficult issue to track as we have never been able to
    recreate it here and none of our customers have been able to recreate it
    reliably either. It seems to only occur on very few of our customers'
    clients' machines and even then in rare cases.

    Any more information you can give about the specific cases it occurs
    would be helpful in finding the scenario to recreate it and address the
    problem.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.