ODBC Linking Problem

[Joe Williams]

I have an Access 2002 front end to an SQL 2000 SP4 back end. I have been
using this application for several years with no issues.

I have set up an SQL userID that has the proper permissions so that when I
link to the SQL server, it prompts me for the password adn then I can link
the appropriate tables and use teh SAVE PASSWORD option.

THe problem I am having now is that when I try to link one of the SQL
tables, I am no longer asked for a userID and password. It is automatically
using the logged in user's password (administrator) and so I cannot enter
the one I created for the SQL database

Then, when a user tries to access these tables, the system tries to use
thier local credentials rather than the SQL username and password that I
specified and they get an access error.

So, the question is, why did Access/ODBC stop asking for the username and
password when linking tables and how do I fix it?

THanks

joe

 

[Rick Brandt]

I have an Access 2002 front end to an SQL 2000 SP4 back end. I have
been using this application for several years with no issues.

I have set up an SQL userID that has the proper permissions so that
when I link to the SQL server, it prompts me for the password adn
then I can link the appropriate tables and use teh SAVE PASSWORD
option.
THe problem I am having now is that when I try to link one of the SQL
tables, I am no longer asked for a userID and password. It is
automatically using the logged in user's password (administrator) and
so I cannot enter the one I created for the SQL database

Then, when a user tries to access these tables, the system tries to
use thier local credentials rather than the SQL username and password
that I specified and they get an access error.

So, the question is, why did Access/ODBC stop asking for the username
and password when linking tables and how do I fix it?

THanks

joe

In your ODBC DSN there is a setting where you can choose between SQL Server
Authentication (what you want) and Integrated Security / Trusted Connections
(what is apparently set now).