Brad Marks
BradM at blackforestltd.com
Tue Dec 3 15:05:31 CST 2013
Stuart, I followed your advice (11/13/2013) and established up a proper web server. I downloaded and installed WAMP (Windows - Apache - Microsoft SQL Server - PHP) on both a stand-alone PC (XP) and on a server (Windows Server 2003). With a small amount of work, I was able to put together a little PHP program that can read data from an Access Database. This program works nicely on both the stand-alone PC and on the Server. My next step is to make this PHP application available to about 10 people on our little Intranet. I have not been able to figure out how to make things on the Apache web server available to people on our internal network. I don't understand how to build the connection between the PCs on the network and the Apache web server which is running on one of our servers. I have checked out 4 books from our local library and I have looks at dozens of sites on the internet, but I have not been able to find the missing piece. I thought that perhaps you or someone here on AccessD could point me in the right direction. Thanks, Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Wednesday, November 13, 2013 9:23 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Problems with Refreshing Access Report on Intranet Your problem is the way the Intranet is set up. Are you using a prpoer web server, or are you just using URLs to a shared folder on your network. It looks like the latter. If you use a web server to serve the PDF, it will not be locked by a user viewing it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On 13 Nov 2013 at 19:39, Brad Marks wrote: > > >>> 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 > >