I have a database stored on a USB drive.
When linking tables/external data files/etc, is there a way I can choose the linked table/file relative to where the front end is?
ie. Not needing to use drive letters, but something like ../directory/abcd.txt.
You see, when I open the database on another PC or laptop, the drive letter assigned to the USB drive can be different, therefore the database doesn't find the linked table.
Thanks.
M.C