task scheduler running macro problem

[Rychertate]

My macro rely on the connection to my ODBC.
UserName, Password, and server names will be prompted.
How can I preset the names so my task scheduler won't stop and wait for someone to enter in names.

Thank you.

 

[DomThePom]

When you initiall set up the connection to the ODBC source the dialog in which you choose tabloes to attach to has a "Save Password" check box - simply check this box and you will not be asked for a password each time you use the connection

 

[Rychertate]

Thanks