[AccessD] Problems with Refreshing Access Report on Intranet

Hi Brad:

It seems that Gustav has the best idea on how to solve it. 

Here is one possible solution: As to copying one file over another, at the time of creation, you could just create a file name from the current date and time, put together as a string. It would be unlikely that a two identical named files would be created and if there was a name collision produced then the system would just pause and try again. It would be easy to find the newest file if needed as it would sort in order. And of course older copies could be just as easily identified and purged.

Just a thought.

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 5:45:37 PM
Subject: Re: [AccessD] Problems with Refreshing Access Report on Intranet

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