How to use Task Scheduler to run a query

[intrepidtechie]

I have a update query that I want to setup to run with a Scheduled Task.
Any ideas anyone.!!!

 

[PHV]

Create a macro calling the query
Then add the /x macroname switch to the scheduled task command line

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[intrepidtechie]

how do I write a macro to call a query and then do the "add the /x macroname switch to the scheduled task command line

 

[dhookom]

intrepidtechie,
How far did you get? Have you looked at macros? Do you have a query? Have you checked Help for any of this including "Comman Line"?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]