MS Access to SQL Default Creditials

2 Oct 2007 8:41 PM

mbaker_mb

We are using MS Access 2002 as a front end to our SQL 2005 server. Our users
have a sign-on for MS Access and a different user account for SQL (we cannot
change this to Windows based currently due to company reasons), when the user
performs a query against the SQL DB it prompts them for their SQL user
information but not before trying to send the current MS Access user
information. While this does not seem to hurt anything we are getting
several failed security attemps in our Event Logs. Is there a way to stop MS
Access from sending the current user ID before it prompts for the correct ID?

4 Oct 2007 5:23 PM

Kai Strang

You might want to try to establish a connection to SQL Server/your database
prior to any queries against the server that Access does on itÂ´s own.

In my experience Access then uses that connection as the default for all
following calls.

Show quote

"mbaker_mb" wrote:

> We are using MS Access 2002 as a front end to our SQL 2005 server. Our users
> have a sign-on for MS Access and a different user account for SQL (we cannot
> change this to Windows based currently due to company reasons), when the user
> performs a query against the SQL DB it prompts them for their SQL user
> information but not before trying to send the current MS Access user
> information. While this does not seem to hurt anything we are getting
> several failed security attemps in our Event Logs. Is there a way to stop MS
> Access from sending the current user ID before it prompts for the correct ID?
>