Distribute DB to many servers

[Rats]

I have developed a db (A2K) which will be distibuted through our companies franchising system to various licensees. These licensees generally operate in a single PC environment but occasionally they will be based on a server network. The single user is fine but I am stumped by the server situation as it impacts on the various links I have set up within the database to files etc that are part of the program but are external such as Excel, Word files. The current links are all set up as C:\MainFolderName\Filename. Of course these all stop working when I place it on a server and link the users up via shortcuts. On our own installation I changed the links to the \\MyServer\MainFolderName\Filename format and everythings fine but due to the number of links this is a fairly lengthy process and I wouldn't want to have to repeat it at every clients installation.

Can any one please advise me if there is a way to set it up so that I could say enter the clients server name in a field. Then insert that field's contents into the pathway details for the links so that they all update automatically.

Your assistance would be greatly appreciated.

 

[Rats]

Thanks for the reply Pat. Just back from leave so I will work with your suggestion now.

Cheers

 

[Rats]

Pats suggestion works well for all the coded links but I can't work out how to insert the DLookup into links that are contained in file name fields such as the "Append to" query dialogue box or the picture field of an Image Frames property sheet. I have tried to modify the underlying SQL statement but keep getting errors.

Any suggestions on how can I modify these links to utilise a links table?

Thanks