Autoenter password

[prabhu]

Hello,

My query which runs every day morning at a scheduled time takes data from a ODBC table, but this ODBC table asks password everytime when i access the table. Is there any way we can enter the password automatically by system. Please suggest...

 

[namliam]

When you setup the Pass through query/ Linked table there is an option to "Save password"

I suggest you check it

 

[prabhu]

Namliam, could you please provide little more information on how to do this?

 

[namliam]

Sorry I cannot...

But sometimes a picture paints a thousand words, see attached