[AccessD] Problems with Refreshing Access Report on Intranet

Brad Marks BradM at blackforestltd.com
Wed Nov 13 19:45:37 CST 2013


Jim,

Good question.

Unfortunately, I am working with a purchased package where that back-end database cannot be changed.

The database is Firebird.

I wish that SQL Server was used, but it isn't.

The long running report also has a lot of conditional formatting, so it appears that at least half of the run time is being consumed by report formatting.

Thanks for your help.
Brad 
  


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Jim Lawrence
Sent: Wed 11/13/2013 3:57 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Problems with Refreshing Access Report on Intranet
 
Hi Brad:

My first question would be what type of backend do you have? An MDB just does not cut it when it comes to complex queries...and there is not much you can do about but...

If you have a real SQL DB that runs SPs, MS SQL Express, MS SQL, MySQL, comes to mind you can use them. Many years ago there was a complex report that would take a full hour for the both halves to complete, from a MDB but less than a couple of seconds on an MS SQL DB.

Jim 

----- Original Message -----
From: "Brad Marks" <BradM at blackforestltd.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Wednesday, November 13, 2013 11:25:20 AM
Subject: [AccessD] Problems with Refreshing Access Report on Intranet

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
This message was scanned by ESVA and is believed to be clean.
Click here to report this message as spam. 
http://h0stname/cgi-bin/learn-msg.cgi?id=81F4B284B2.0D781





More information about the AccessD mailing list