MS Access to SQL Default Creditials

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

Guest

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.
 

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

Access 2007 Application for Reports Only – SQL Server Security 3
MS Access or SQL Server? 2
encrypted communication between Access and SQL Server 1
Workgroup permissions for Access 97 DB (permissions error) 1
Security strategy: Access client/SQL Server 4
Running ms access modules as admin but logged into access as a regular user.. 2
Picking authentication when linking Access to SQL Server 1
Query problem (MS SQL and MS Access tables) 2

Top