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.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link from SQL server 1
How to manage SQL Server authentication in Access2007 1
Retrieve ODBC password 6
Access to remote SQL server 14
Can VBA Plug in ODBC password? 5
Query a sql server directly 1
Errors reported by SQL to Access 1
Unable to update/add records in connected SQL Server tables 4

Back
Top