Brad Marks
BradM at blackforestltd.com
Wed Nov 13 13:25:20 CST 2013
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