The general solution is to cobble together some code.
It really depends on your customer, and the application. For example, I have
one application where I can enter the new pathname into a form (it is a
table in the front end with one records). I also have a check box to
"re-link" One field is for my development pc, and the other field is for the
production version. If the check box is checked, then a re-link occurs at
start-up to the new path name. This works, since I already know the path
name and server name of this particular client. Thus, I can send updates via
email to them, and don't have to worry about re-linking.
Another way (which is even better) is to simply pop up the file browse
dialog and have the user browse to the back end mdb file. The majority of us
have thus cobbled code together from the two following pieces of code.
File open dialog:
http://www.mvps.org/access/api/api0001.htm
Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm
So, in effect, you actually will wind up writing your own linked table
manager. What you do with the above two routines is really up to you, but at
least they are already written for you. So, in a few hours of time you can
easily setup what you need, and what is even better, is that you can tailor
the above code to your particular needs.
I would also spend some time at the above mvp site, as there is a ton of
good stuff there.
