Automate log-in/passwords with ODBC connections

[Guest]

I have my database linked to some tables ODBC, I have queries that run off of
these tables that puts only the information I need into some other
(non-linked tables). I want to have this get updated automatically, my on
issue is the linked tables have to have a log in and password, is there any
way I can automate this part?

 

[Guest]

Usually when you link this table you have an option that says sasy "save
password" check this option, it that does work, then I sugest to check with
you DB Admin, looks like the conection type to this tables is by "System/User
autentification" which will promp you for the user name and password every
tyme, if your DB Admin set your connection as SERVER AUTENTIFICATION then the
server will check for your PC's credentials and let you go with no furter
questions.
I hope this helps.