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?