Repair broken Linked Tables

[apoll0]

I've search the forum but couldn't find anything on this, maybe someone can point me in the right direction...

My application consist of two Access files: Front End & Back End. The front end is linked to the back end using Linked Table Manager. A problem arise last week when the IT renamed one of the folder in the program path, as a result, the Front End file cannot find the Back End file (I guess the links were static). So I had to relink the tables manually and got it working again. However, in the future, I won't be around to relink the tables, and my client doesn't know how to do this (and I don't want them to have to do this every time the folder is moved).

My question is, is there a way to link it so that it will adapt to path name changes. The two files are in the same folder.

I am looking for something like: when the front end opens, if the link is broken, it relinks it to the data file in its current database folder. Thanks.

 

[Len Boorman]

I too would be interested in a method but I do not believe there is a method.

IT should not rename/move folders as they feel fit. They should know better.

Tonight our IT are renaming a server. They have warned us which is something but it is going to be a shambles here in the morning.

Len

 

[DBL]

This is what I use and it works well.

http://support.microsoft.com/?kbid=209862

I'd like a solution for tables that are in different databases if anyone's got one.