ASP, Access 2K and automation

[Dave]

I'm using W2K server, Access 2K and ASP.
Creating website to provide database information to anonymous users.
I know Access can support very few online users at a time, so I'm thinking
about automating database interaction. The idea is to have ASP call on
Access at midnight. Once the connection is made a new HTML file is generated
for the website which would be used for the next 24 hours.
Ultimately, Access would only be queried twice a day; once to update the
database and secondly, to generate the HTML. Would I need an ASP script to
watch the 24 hour intervals, call on an Access macro and finally update the
web page HTML?
Considering this involves several programs; I'll be posting my question to
other newsgroups.

TIA,
Dave

[Ray at]

Hi Dave,

If you have access to the server, you can write a vbscript file to generate
your new HTML files and schedule it to run every 12 hours using either the
task scheduler service or the AT command, which is part of the task
scheduler service. If you can get your VBS file written, you could then
schedule it by entering this at the command prompt.

at 0:00 /EVERY:M,T,W,Th,F,Sa,Su D:\YourPath\YourScript.vbs
at 12:00 /EVERY:M,T,W,Th,F,Sa,Su D:\YourPath\YourScript.vbs

Ray at work




"Dave" <dgrisset@sewanee.edu> wrote in message
news:%23Trgn6HTDHA.2676@TK2MSFTNGP10.phx.gbl...

> I'm using W2K server, Access 2K and ASP.
> Creating website to provide database information to anonymous users.
> I know Access can support very few online users at a time, so I'm thinking
> about automating database interaction. The idea is to have ASP call on
> Access at midnight. Once the connection is made a new HTML file is

generated

> for the website which would be used for the next 24 hours.
> Ultimately, Access would only be queried twice a day; once to update the
> database and secondly, to generate the HTML. Would I need an ASP script

to

> watch the 24 hour intervals, call on an Access macro and finally update

the

> web page HTML?
> Considering this involves several programs; I'll be posting my question to
> other newsgroups.
>
> TIA,
> Dave
>
>