Schedule Access to Run at 2AM

[Fattire]

Is there a way to get an Access DB to just open up by itself and run at say...2AM M-F?

I have queries tied a 'Form Load' event that runs when it opens.

I'd like to avoid using XP's Task Manager (that's what I use now) as I am tired of re-inputting the password everytime my NT password changes.

 

[jrbarnett]

Look at the AT command from the command prompt.
You can set scheduled tasks up from there.

AT /? for more help

See also

http://www.ss64.com/nt/at.html

John

 

[lamarw]

When you said you used the Task Manager were you referring to 'Scheduled Tasks'? If not then you might look at that in XP. It's like setting up a CRON in unix. Simple interface found in the Control Panel|Performance and Maintenance|Scheduled Tasks|Add Scheduled Task (wizard)

 

[petrosky]

Hi Fattire,

I would run the task under a user name that has appropriate priveledges but whose password is set to never expire.

Regards,

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[mp9]

See also the Handy Access Launcher, which may be of some use

http://www22.brinkster.com/accessory/resources/001.shtml