title: Update an Access linked table to use a UNC path
body: <p>I have an Access 2010 database <strong>A.mdb</strong> with a list of tables, one of which is a linked table, linked from another Access database <strong>B.mdb</strong> on the same server. These databases are on a development machine <code>xxx.xxx.xxx.xxx</code>, which is mapped on my computer as <code>R://</code>, and they are afterwards published online on a <code>yyy.yyy.yyy.yyy</code> server. </p>
  
  <p>If I want to work on the database locally, I need to change the link to the table. But if I change it via filesystem (using the "Linked Table Manager"), the link becomes <code>R://....</code> and when I look at the ASP page that requests those data, it is broken because the path is wrong. Also, if I change the link locally, it won't work on the online server. </p>
  
  <p>Is there a way to change the link "programmatically"? That is, without using the Linked Table Manager?</p>
  
  <p>I searched for an answer, but I am not that expert, I just understood that I have to write a "Module"? "Macro"?</p>