I encountered a VERY similar issue just yesterday. See this site:
http://www.mvps.org/access/api/api0003.htm

Run the cose from a module and look at the results in the 'Immediate
Window'. If you don't have the Immediate Window open, click View Immediate
Window in the Visual Basic Editor. Look at the results. Find your drive.
That is called the UNC Path. See this:
http://support.microsoft.com/kb/328440


Regards,
Ryan---

--
RyGuy


"Code Numpty" wrote:

I have designed a template with lookup formulas referring to other files. I
have specified the other files all be in a folder directly on the C: drive,
C:\Masters.

When I distribute the file to another PC the file location changes. Is there
any way for it to stay exactly as input, whereverthe final file is saved as a
file or template?