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