ODBC Automatic login

[Metrazal]

I have a situation where I need to schedule the execution of Access using the Windows task scheduler and run a macro. The issue I have is, when I run my queries I need to be able to access tables linked via an ODBC. I have a login ID and password but since this is a scheduled event, I am unable to input this information. Is there a way to setup a autologin for ODBC as a end user?



Thanks,

Met

[pbaldy]

Are you aware you can check the Save Password box while linking tables and you won't get prompted for them when using the db?

[Metrazal]

Doh! How did I miss that? Thanks for your help.

Met

[pbaldy]

No problem!