I am looking for code that will update the individual filepaths within a database that can be used for 100's of databases. We recently changed servers and now I need to update the filepath for all the linked tables within all my databases.
Does anyone have some code that will simplify my task. Right now I have been using the Linked table manager and opening each mdb individually
Keep in mind that 1 database can have numerous linked tables from various sources.
Any suggestions would be greatly appreciated.