I'd like to write a script that would run on a server that would assign a 

value to a Cell in an access database at 12:01am every day.  I need this 

script to run at exactly that time without any human interaction.



is it possible to to this in ASP?  could I possibly tell the server to run 

the page that I put this script on at 12:01?



I know how to write a script that will update the database when promted by 

a user, but, can I have the server do it automatically?



thanks,

-js

I'd always done it via an 'at' command.  It's a command-line scheduler.

You can read about the syntax in Windows Help and typing "at command,

using the at command" into the index.



You can also accomplish this by going to Control Panel, Scheduled Tasks

and using their Scheduled Task Wizard.



Beth



-----Original Message-----

From: jason andrew shope [mailto:epohs@h...]

Sent: Thursday, January 10, 2002 11:37 AM

To: ASP Databases

Subject: [asp_databases] create a script that runs independantly of a

hit on page?







I'd like to write a script that would run on a server that would assign

a

value to a Cell in an access database at 12:01am every day.  I need this



script to run at exactly that time without any human interaction.



is it possible to to this in ASP?  could I possibly tell the server to

run

the page that I put this script on at 12:01?



I know how to write a script that will update the database when promted

by

a user, but, can I have the server do it automatically?



thanks,

-js




$subst('Email.Unsub').

You could schedule a task to run at that time every day, and tell the

teask to load the webpage with the code in it.



OR

You could write a wsh file containing your vbscript code to update the

access database, and run that on a scheduled task.



I think there's been talk of a command line utility to do this a few

months ago on the list.  Try the archives



-----Original Message-----

From: jason andrew shope [mailto:epohs@h...] 

Sent: Thursday, January 10, 2002 7:37 PM

To: ASP Databases

Subject: [asp_databases] create a script that runs independantly of a

hit on page?





I'd like to write a script that would run on a server that would assign

a 

value to a Cell in an access database at 12:01am every day.  I need this



script to run at exactly that time without any human interaction.



is it possible to to this in ASP?  could I possibly tell the server to

run 

the page that I put this script on at 12:01?



I know how to write a script that will update the database when promted

by 

a user, but, can I have the server do it automatically?



thanks,

-js




$subst('Email.Unsub').