Auto refresh linked tables, when front-end file moved
Auto refresh linked tables, when front-end file moved. Relink to current folder if back-end not found.
Best usage is to split front-end from Jet back-end.
Often we move this 2 files to a new location, but then we have to relink manually. Imho, it would be nice to have an automation\option that detect that we moved the front-end file, and that relink to the back-end in the current new folder (the same as FE folder). Of course it should be optionally, because many times we leave the BE in the same old location on the network LAN. Thanks for reading.
Anders Ebro (TheSmileyCoder) commented
I suggest you try looking at the relinker tool which can be found on Armen Stein (MVPs) website:
It should solve your needs quite elegantly.