[AccessD] Problems with Refreshing Access Report on Intranet

Gustav Brock gustav at cactus.dk
Thu Nov 14 01:06:24 CST 2013


Hi Brad

I think Stuart nailed it. Viewing the PDF should not lock it.

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Brad Marks
Sendt: 14. november 2013 02:40
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Problems with Refreshing Access Report on Intranet

Gustav,

Thanks for the assistance.

I changed the creation of the PDF to go into a working folder.

I then added a small step to copy the PDF file from the working folder to
the folder that the Intranet uses.
This step uses a .bat file (Copy C:\Staging\Test.PDF C:\Intranet\Test.PDF) 

When I run this two-step process, I still run into problems if the PDF file
in the Intranet folder is in use when the second step is executed.

I am wondering if there is any Windows Utility that can copy from A.pdf to
B.pdf when B.pdf is opened.

Thanks,
Brad 
   


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Gustav Brock
Sent: Wed 11/13/2013 3:30 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Problems with Refreshing Access Report on
Intranet
 
Hi Brad

Right after the creation of the PDF in a working folder, you could copy it
to the folder users reach.

/gustav

>>> BradM at blackforestltd.com 13-11-13 20:25 >>>
All, 

We use Access 2007 to create a large number of reports from data that is
stored in a purchased package system.  This works very nicely.

Recently, we have built a new report that shows "production schedule
information".  Our users really like this new report, the catch is that it
takes about 2-3 minutes to generate it.

Because of this long generation time, I have set up a scheduled task to run
every 15 minutes to generate this new report.  The output is exported as a
PDF file.  One of the pages on our Intranet has a link to this PDF file.
This approach has worked nicely.  

Our users really like being able to obtain this report instantly via the
Intranet rather than waiting 2-3 minutes when they generate it via the
Access application.

There is one problem, however.  If any user is viewing the PDF file when the
"refresh job" is running, the refresh is not able to place the new PDF file
in the Intranet's folder.

I am curious if anyone else has run into this problem and has ideas on how
to work around it.

Thanks,
Brad





More information about the AccessD mailing list