relinking tables 1

[mikemansker]

I am interested in location something that will give users of a distributed runtime application the ability to relink backend tables to the front end database if they move the data to another location.

Does anyone know of a "canned" solution for this? Ideally, the routine would check for broken links and if the backend tables can't be located, prompt the nontechnical user for their location. It must allow for moving the backend database to a folder other than the one containing the frontend. This must also be a distributable solution.

Any help would be appreciated.

Thanks,

Mike

 

[lupins46]

http://www.mvps.org/access/tables/tbl0009.htm

 

[mordja]

mikemaster,

See thread705-898838 for a chunk of code related to this.
I posted this question a while back and got a pretty good reply. I used the code that was given to build a function that would return a false if any tables were unlinked. I called this function from the autoexec of my front end, if it returned a false a popup form would appear and prompt for the new path of the backend. It would then use another variation of the given code to check and relink to the new path. The popup form would not close until the tables were relinked.

Mordja