title: MS-Access Add Additional Linked Tables
body: <p>I have an MS-Access database that was converted to use SQL Tables using the "Microsoft SQL Server Migration Assistant 2008 for Access" (aka SSMA) and created linked tables (so the MS-Access interface still works but is linked to SQL Tables).</p>
  
  <p>Modifying those tables has been no problem (modify in SQL, use the Linked Table Manager in MS-Access, update tables).  But I've not added a new table in SQL and I can't find a way to add that table to the set of linked tables.</p>
  
  <p>I've tried the External Data -> ODBC Database, but it wants me to make a FileDSN and since the SSMA tool didn't require that I don't want to have some tables linked one way and other files liked another way (does anyone know how SSMA links the tables?).</p>
  
  <p>So my underlying question is:  Without using DSN how do I add an additional SQL Server table to MS-Access as a linked table?</p>