MS Access to SQL Default Creditials

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top