title: How to programmatically update all linked table references in MS Access
body: <p>I would like to update the linked table references of 60+ tables/excel files in a MS Accecss database:</p>
  
  <p><a href="https://i.stack.imgur.com/QaMf6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QaMf6.png" alt="enter image description here"></a></p>
  
  <p>However I do not want to go into all 60+ manually as the file-path will simply need to change "F:"..." to "E:...".</p>
  
  <p>How can this mass reassignment be done programmatically? </p>