Updating graph automatically with the database data to Excel with ASP

[Guest_imported]

I'm developing a web-application with ASP, which retrieves data from the database and passes results to Microsoft Excel 2000. It also creates a graph (with OWC - Office Web Components) which is saved to web-server as a *.gif -image. This image is deleted when it's older than 10 hrs.

This image is then got to Excel with <img src ... > -tag.

This data and graph-image is got to Excel ok. The problem is that can it be updated after a certain time (e.g. every 5 minutes), defined by the user?

The script already retrieves the _actual_ data from the database dynamically.

But is there point to make the automatic-thing to it.

Basically, that refreshing can be done by pressing BACK-button and then running the script again. Problem should be expected if user is modifying his/hers data and &quot;forgets&quot; the refresh-time and the script loads it again?

That cannot be (?) done with <meta http-equiv=refresh content=&quot;&quot;5; .... > -tag.

ASP is probably not the best solution to do this, since the script is &quot;idle&quot; due to the page is loaded.


Im using: NT4 Server (Service pack 5), IIS4, SQL Server 7. And the application is used with IE5 and newer.

Any suggestions?