title: Linking MS Access to SQL Server with Windows Authentication
body: <p>I have a Microsoft Access database that contains links to tables on a MS SQL Server.  These links work fine for me using my Windows Authentication because I have been given full access.  I have requested access from our IT department for other users.  They would not do that.  Instead they provided a new windows user ID and password that has access to the SQL Server we need.</p>
  
  <p>I have tried using SQL Server authentication when creating the link, but it doesn't work.  Is there any way to use Windows Authentication but provide this user name and password to the database?  That would allow me to send out a copy to all users, giving them access.</p>
  
  <p>I can't have all users logging in to Windows using that same account, so I need a way to specify to MS Access to use the provided user name and password.  Any help is appreciated.</p>