ASP: Auto Checking *ADVISE

[borisding]

Hi there,

I'm currently using ASP classic/VBScript and Database is Microsoft Access 2003 SP3 for my web development. Basically, I need to come out a function that able to do the yearly check, based on the value of suppliers in database. If the value does not exceed the limitation, then it will be reset (updated).

Well, I have some thoughts in my mind, may have advises from you guys if have any better ideas:

a) Should I use Windows Task Scheduler for executing the code (yearly) in order to check the value by setting the date?

b) Or, whenever supplier logged on to the system and trigger the function for checking the value? and therefore decide whether to update/remain the value before displaying it?

Should you guys have any better idea/logic? May have your advises on this.

Thank you in advance!

[jhardman]

I can see reasons for doing it both ways. If one of the reasons the supplier logs in to the system is to verify the numbers, then I think running it from the ASP page is the logical way to do it. However, if the number needs to be updated regardless of whether anyone checks it, then the scheduled task makes more sense.

Jared