Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Setting up a query to run automatically

Discussion in 'Information Technology' started by joshroberts, Jul 28, 2006.

  1. joshroberts

    joshroberts
    Expand Collapse
    Guest

    I have a query linked to a large external table that I'd like to set up to
    run when I'm not around (i.e. weekend or at night). Can I do this by setting
    up a windows task or is there another way? Thanks for your help.
     
  2. Loading...

    Similar Threads Forum Date
    General Great Production of English Songs and scene settings Videos Oct 11, 2012
    Hinduism Why is there Dancing in Bhajans or in Mandir Settings? Interfaith Dialogues Feb 18, 2011
    Personal Goal Setting. Why Set Goals? Business, Lifestyle & Leisure Oct 23, 2010
    Rise in Extremism or Rise in Hysteria? Canadian Sikhs Setting the Record Straight Hard Talk Apr 25, 2010
    Sikh News Badal invited to Pakistan for setting up of Nanak varsity (New Kerala) Breaking News Nov 23, 2009

  3. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    Hi Josh - Yeah, no problem. Create a new empty DB - link to your table only
    and add the query you want to run. Create a macro to run the query, and then
    do either :

    -on Startup run the macro by running the command line switch /x macroname
    This starts Access and runs the specified macro.

    -when you open the database make your macro an AutoExec macro.

    Then set up your task.

    Yours - Dika

    "joshroberts" wrote:

    > I have a query linked to a large external table that I'd like to set up to
    > run when I'm not around (i.e. weekend or at night). Can I do this by setting
    > up a windows task or is there another way? Thanks for your help.
     
  4. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    Let me expand a little. You set up the task with the Windows scheduler.
    Don't forget to leave your PC on so the job will run. If you want to run
    the job on the server, the server needs to be running some version of
    Windows (Unix won't cut it) and Access MUST be installed on the server.

    "Kernow Girl" <KernowGirl@discussions.microsoft.com> wrote in message
    news:A11C9090-535B-46CB-9FFB-0D20A882FF91@microsoft.com...
    > Hi Josh - Yeah, no problem. Create a new empty DB - link to your table
    > only
    > and add the query you want to run. Create a macro to run the query, and
    > then
    > do either :
    >
    > -on Startup run the macro by running the command line switch /x
    > macroname
    > This starts Access and runs the specified macro.
    >
    > -when you open the database make your macro an AutoExec macro.
    >
    > Then set up your task.
    >
    > Yours - Dika
    >
    > "joshroberts" wrote:
    >
    >> I have a query linked to a large external table that I'd like to set up
    >> to
    >> run when I'm not around (i.e. weekend or at night). Can I do this by
    >> setting
    >> up a windows task or is there another way? Thanks for your help.
     

Share This Page