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