access and sql server

  • Thread starter Thread starter Spencer.Sadkin
  • Start date Start date
S

Spencer.Sadkin

hey all,

everytime i access a table from odbc acess pops up a sql server login,
anybody know a way to save the password so you dont have to type in
the password everytime you access a new server?

thanks in advance
 
You can include the user name and password in your connect string or you can
use a Trusted Connection.
 
If you are linking to the SQL tables using the FILE > GET EXTERNAL DATA >
LINK there is a checkbox available during that process whereby you can
specify for Access to keep the password.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________
 
Back
Top