title: Delete all linked tables in VBA
body: <p>I need to delete all tables which are linked in my access database.</p>
  
  <p>This is the query which is returned all the linked tables (odbc and access linked tables) : </p>
  
  <p><code>SELECT [MSysObjects].[Name]
  FROM MSysObjects
  WHERE Left([Name],1) &lt;> "~" AND (MSysObjects.Type = 6 OR MSysObjects.Type = 4)
  ORDER BY MSysObjects.Name;</code></p>
  
  <p>But now i think i have to do a <code>for each</code> with this <code>DoCmd.DeleteObject acTable, Table.name</code> in order to close all my tables, but i don't know how to do.</p>