This is going to sound incredibly weird.

On the first day of each month, I need to update a table with values that I can only get by running a chunk of code which is based on tables from the same database. This code computates certain values and updates a the database with the new values. I would do it each time a recordset is needed however it takes a lot of time to process.

Here is my delimma. I don't know how to set up the scheduling of it. Could I set up a stored proceedure in my SQL7.0 db that runs when its 1am on the first of the month and executes a shell command to run the vb exe that I create to bring in the data do the computation and then the update? Or is it possible to put this in an activeX dll (including the monthly scheduling)?


HELP HELP HELP