Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    The Netherlands
    Posts
    3

    Question Unanswered: Run an access function at night.

    Hi,

    I have other problem as well. I want to run an inport function for Access at night. It has to be a script that can be run by a tasks manager.

    Tnx,

    Gerard

  2. #2
    Join Date
    Oct 2002
    Location
    Sweden
    Posts
    2

    re:

    You will need to setup some script in your autoexec of the access database... then as long as ms access is installed on the machine and its a server you can use the AT command or WINAT program to schedule when the db should do its work.

    An example of this:

    MACROS: autoexec

    SetWarnings = off
    RunCode (start function) and/or
    OpenQuery(Query Name)
    Quit (SaveAll)

Posting Permissions

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