Schedule a Job

[ramdil]

Hi All

I have a doubt regarding the scheduling a task in msaccess.I want to write a query which will insert into a temporary table from a exisiting table.I have written the insert query but i want this query to be executed automatically every midnight..How can i schedule it.I know about windows scheduler,but dont know can i schedule access querys.Should the scheduling job should be in the same machine where access has its querys.Thanks in advance

[NeoPa]

You need to :

1. Design a database that opens automatically into a form where you execute the code you need.
2. The code should handle closing itself down.
3. Schedule a task that opens the database (possibly with a parameter to indicate it's to work in this particular way).

[ramdil]

Hi
Thanks for the reply.But sorry to disturb as can you be little descriptive about the steps to be done.

Thanks in advance...

You need to :

1. Design a database that opens automatically into a form where you execute the code you need.
2. The code should handle closing itself down.
3. Schedule a task that opens the database (possibly with a parameter to indicate it's to work in this particular way).