title: Linked table ms access 2010 change connection string
body: <p>I am working on a existing MS Access 2010 project that has a linked table link to Sql Server database.</p>
  
  <p>When I mouse over to the linked table I can see a connection string <code>'ODBC;DRIVER=SQL Server;SERVER=10.0.0.1;UID=testdb;APP=Microsoft Office 2003;WSID=abc;TABLE=dbo.user'</code></p>
  
  <p>This looks like a dsn-less linked table.</p>
  
  <p>Question </p>
  
  <ol>
  <li><p>Where the connect string locate at? How to change it (example database name)? </p></li>
  <li><p>How can I create a similar dsn-less linked table? Anytime when I create a linked table Access 2010 always force me to choose\create a dsn (file or machine).</p></li>
  </ol>