ODBC Password - SQL Server

[Steve Andrews]

When I set up an ODBC Connection with SQL Server,how can I
get the password to be saved so that the user isn't
prompted every time they open the linked SQL table?

 

[Rick Brandt]

When I set up an ODBC Connection with SQL Server,how can I
get the password to be saved so that the user isn't
prompted every time they open the linked SQL table?

When you create the links there is an option to save the password as part of the
connection string. This can be disabled on the server though. Have you thought
about using integrated security instead? Then the password is a non-issue.