title: Manually Close ODBC DSN Connection
body: <p>I have an MS Access database that connects to another database via a user level DNS ODBC data source. </p>
  
  <p>When the connection is first initiated the ODBC driver will prompt me for a username and password. The database that it then connects to on the server is dependent on the username I use.</p>
  
  <p>Once the connection is established Access will retain / keep it alive until I close the Access database.</p>
  
  <p>Is there a way to force Access to close all open ODBC connections, requiring me to provide the login credentials again when I next try to access an object on the server. What I want to be able to do is switch which database the ODBC connection is accessing without having to completely close Access and re-open the database.</p>