Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Unanswered: How can I auto run a query at a certain time of the day?

    I recently inherited a database that is in need of modification.
    Access is not my forte'

    Here's the scoop...
    (Any interjections will be more than welcome)

    There are 13 tables I need to check information in daily.
    Each table has an auto-incrementing "id" field.
    I think I will need to use that field to pull the most recently entered record (highest number in "id" field of each table.)
    I will need to , in each table, check one or more fields to see if the data within them falls within a range of parameters (mostly greater than and less than), then if the data falls out of the parameters I need it to generate a report with the contents of the field and a warning message that corrective action may be needed. This will need to be sent out to one or more email recipients.

    Is there any way that I can set up some kind of auto-task to run this daily?
    What is the best route to get this started?
    Any design tips will be greatly welcomed...
    Thanks.

  2. #2
    Join Date
    Sep 2003
    Posts
    228
    I create a batch file along the lines of:
    Code:
    "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "c:\db.mdb" /x "MacroName"
    EXIT
    Then I use Windows Task Scheduler on my server (yes it is windows) to run this batch file on a nightly basis.

    If there is a better way would someone please post it here!

Posting Permissions

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