Hi
I am in the process of designing a Intranet Site using Front Page. In the website there are a number of charts using Office Web Components which require data from an Access DB. The DB itself takes a data dump every 15 minutes from a SQL DB. This is to ensure that the data is up to date without having to requery the main server every time someone accesses the Intranet Site.
I currently running this on my own machine before moving to the Web Server.
I was wondering what would be the best way to schedule the updates?
Currently I have a scheduled task on my machine which runs every 15 mins. This reads a batch file which in turn opens a macro in the DB which runs the required queries and then closes. This works fine though it means that I have the DB popping up every 15 mins on my machine which is a pain.
I could also open the DB and schedule the updates to run every 15 mins using a form timer but this would mean that for 14 minutes 55 seconds it is just sitting there using resources.
Can anyone suggest anything better?
Thanks in advance.
JC
I am in the process of designing a Intranet Site using Front Page. In the website there are a number of charts using Office Web Components which require data from an Access DB. The DB itself takes a data dump every 15 minutes from a SQL DB. This is to ensure that the data is up to date without having to requery the main server every time someone accesses the Intranet Site.
I currently running this on my own machine before moving to the Web Server.
I was wondering what would be the best way to schedule the updates?
Currently I have a scheduled task on my machine which runs every 15 mins. This reads a batch file which in turn opens a macro in the DB which runs the required queries and then closes. This works fine though it means that I have the DB popping up every 15 mins on my machine which is a pain.
I could also open the DB and schedule the updates to run every 15 mins using a form timer but this would mean that for 14 minutes 55 seconds it is just sitting there using resources.
Can anyone suggest anything better?
Thanks in advance.
JC
