Hello,
I need to run a task on a password protected database nightly. However, when I try to use windows task scheduler I am prompted for a password before I can get to the autoexec to start. Any way I can get the task scheduler to enter this password?
Should I have the task scheduler open say an excel file and put the vba in there to open the database and enter a password?
Any ideas?
Thanks!