VBA Relinking of Tables from multiple back-ends
Posted on 2013-05-16
I wish Microsoft would make it easier to relink tables from multiple backends. If you don't select only tables from a single source you need to keep re-selecting the path to the backend you wish to link to instead of doing it once...
I have an app that has 3 different sources of data and it's a drag to relink when I need to push out test version (attached to test back-ends) to the live environment several times a week.
I have code to relink and have used it tons of times -- but can't seem to be able to specify which back-end table to link to.
Anyone have any ideas?