How to manage SQL Server authentication in Microsoft Access 2007

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
 

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

How to manage SQL Server authentication in Access2007 1
Access 2007 Application for Reports Only – SQL Server Security 3
Manual prompt needed for SQL database Authentication 0
Access 2007 and SQL Server 2008 Express Logon 1
ODBC Failure, error 18456 1
Picking authentication when linking Access to SQL Server 1
Using Windows Authentication 10
ODBC Access to SQL 2000 0

Top