Thanks very much guys.
I will play around with that code later. I can confirm that the LTM process works and as you said the whole path isn't visible. Not a big issue because the path is totally visible for the BE and I can guess the path for the FE since the path is on my PC.
The tables in the FE are linked to the BE file that is on my PC. This is the way the program always worked. For example, when the FE was updated, it would have to re-connect with the BE file.
The tables in the FE are more interesting. Even though the tables look normal (no arrow icon), the LTM mentions a completely different mdb file and folder path that isn't on my PC. I assume this could be the master file.