You might check out the following URL that has code to link tables.
http://www.mvps.org/access/tables/tbl0009.htm

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

JK wrote:
Thanks for the reply.

I tried to navigate through using the network places, however I cannot
access the folders on the server that way. The next folder down on the
server is not an option. (Ex. \\fadsf-afs\ew$) I can type that in a
windows explorer and get to the folders I need, but when I use the network
places ew$ is not an option I can select. I'm 100% positive that I am
navigating to the correct server when using network places.

I do not know how to correctly set the path using code. I'm pretty new to
writing code in Access so my knowledge on the correct syntax and where to
place the function, like when the program opens or when a form opens, is
limited. I don't even know how to run a function when the program is first
opened automatically.

If I have the people just change the path manually using the link table
manager on the front end they have on their computer, will this resolve the
issue?