title: How are ODBC connection credentials stored in MS Access?
body: <p>I have an Access database that uses a login form to establish a connection to SQL Server using ADODB.Connection. The connection string contains the user credentials entered into the login form.</p>
  
  <p>In a normal Access situation, if a pass through query is submitted with user credentials in the connection string, Access saves the credentials for use by other queries during the session, even if those queries don't include the credentials.</p>
  
  <p>I would like to know how I can use the ADODB.Connection to login a user and then have Access automatically use the credentials when sending pass through queries going forward. </p>