linking tables to external ones?

My database links to two tables in another access database and also to two excel spreadsheets. At work these and the 'main' database are all in the same folder with other stuff. However I often put this entire folder on a memory stick and/or copy it to my laptop to work on.

Is there a way I can set up the linking so that it will always look in the folder where the 'main' database is without having to manually re-link each thing separately? (something like application.path in VB)


Especially as the linked table wizard window is too small to see all of the long pathnames in modern machines.

Howard

(cross posted also to the tables forum - apologies)
.