View Single Post
  #4 (permalink)  
Old January 29th, 2005, 08:14 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

You could write a VBScript and schedule that with the Windows Task scheduler. This is probably the easiest solution; VBScript is pretty similar to ASP (actually the other way around) so there is a fair chance you can use existing pages.

If you're using SQL Server you can also use the SQL Server agent to schedule database tasks, like clean-up stuff.

You can also write a Windows Service. This is easy in .NET, but not in VB 6.

All these methods require some sort of access to the server. If you cannot control the server at least a little bit, you're stuck with what mega suggested; have you clients trigger the functionality.

For example, on Session_OnStart you could run the clean up. On a bust site, you could clean up every 100 or 100 users....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote