When working on databases with linked tables with UNC type paths I often have to relink all the tables when I do development in another location. Sometimes I'll write a re link module to do this but I'm wondering if someone has figured out how to make some kind of alias to avoide this.
Here is an example:
My clients database front end has table links like - //SERVER1/DATABASE
My office LAN does not have a server named SERVER1 it has a server named SERVER2.
I want to put the backend on SERVER2 and run the fronend without relinking the tables.