How can I schedule an Access 2000 delete query?

[jamesk1979]

I need to schedule a delete query in Access 2000 to run daily, using the Windows NT Scheduler. Each time I try the task fails, even when (I think) I have the correct address in the scheduled task.

I can't use the HAL utility mentioned before, due to licensing issues.

Any help will be much appreciated.
Cheers.

 

[ETID]

If NT works similarly to Win2k then,

Right click on the query...

Then create a shortcut to a folder of our choice...

then use windows scheduler to run the shortcut.

 

[jamesk1979]

Cheers ETID, will give it a go.

 

[mp9]

Licensing issues? HAL is freeware.