<div>
<div class="content wysiwyg-content">
I have a tool that references linked tables from 2 other tables. &nbsp;I know both the locations of the MDBs and the table names where they reside. &nbsp;I am further using a macro to link the tables by using the currentproject.path variable with the assumption that all MDBs will reside in the same folder. &nbsp;However, when I copy the MDBs to another folder, after linking the tables, I cannot see the data in the linked tables. &nbsp;Is there anyway to automate the update linked tables to the new folder contained in &quot;currentproject.path&quot; in VBA?<br />
<br />
Thanks<br />
Vishalarya<br />
<br />

</div>
</div>


I have a tool that references linked tables from 2 other tables.  I know both the locations of the MDBs and the table names where they reside.  I am further using a macro to link the tables by using the currentproject.path variable with the assumption that all MDBs will reside in the same folder.  However, when I copy the MDBs to another folder, after linking the tables, I cannot see the data in the linked tables.  Is there anyway to automate the update linked tables to the new folder contained in "currentproject.path" in VBA?

Thanks
Vishalarya



Automatically update linked tables MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.