Professional Web Applications Themes

ASP, Access 2K and automation - ASP Database

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

  1. #1

    Default ASP, Access 2K and automation

    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


    Dave Guest

  2. #2

    Default Re: ASP, Access 2K and automation

    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" <dgrissetsewanee.edu> wrote in message
    news:%23Trgn6HTDHA.2676TK2MSFTNGP10.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
    >
    >

    Ray at Guest

Similar Threads

  1. IAC using OLE automation in Acrobat 9
    By VladV in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: October 24th, 09:08 AM
  2. OLE Automation
    By Curt_Stone@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 6
    Last Post: November 14th, 06:37 PM
  3. Web automation
    By BOTAUH in forum PERL Modules
    Replies: 1
    Last Post: August 20th, 07:42 AM
  4. OLE automation issue
    By Andrew Rowlings in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 2nd, 12:12 AM
  5. COM Automation anyone?
    By Bernard in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 0
    Last Post: June 28th, 03:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139