In my database, i have several excel files linked as tables into the database. When the database is moved from one computer to another, the links are broken because the same drive or directory may not be available.

Is it possible to dynamically change the pathname to the linked tables/files in VBA?

Is not possible to change the path to a linked file/table . You will have to delete the old link and re-create the links.

Note - if the files are located on a server, then use the UNC path rather then Drive mapping letter (the drive could be mapped by using different letters )

Thanks, I was afraid of that. It also explains why I couldn't find any reference anywhere to doing it.

Instead of a static link, I may just hard code the importing of the data, that way I can control the source path.

Thanks, Dave