How to manage SQL Server authentication in Access2007

  • Thread starter Thread starter Amos Sobel
  • Start date Start date
A

Amos Sobel

I have an Access 2007 application using an MSSQL 2005 Database and Views. The
SQL 2005 is using SQL Server authentication with a password. The ODBC
connector is using the same password. On each activation of the Access
aplication, I am requested to enter the sa user password (authentication) one
or more times and this have become a hassle.
How do I enter the SQL authentication password into the Access aplication
such that it will enter the sa password whenever nessasary.

your help is very wellcome

Amos Sobel
 
Back
Top