D
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
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