Update Links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that functions using three database containers, (2 FEs and
1 BE) that I transfer between two machines using a Flash drive to do
programing when time allows. Every time, however, I must update the links
manually. Is there a utility in vba that I can put in Startup or On_Click
that does this automatically? Help much appreciated.
 
Not sure what you mean by "update the links"? Are you saying that you need
to re-point the front-end to the back-end? If so, why? If you use a
UNC-naming convention for your links, you won't be limited by the local PC's
named shares.
 
Thanks, Jeff. Unfortunately, I know nothing about UNC-naming conventions.
I've done a google search but unfortunately, what I find is mostly Greek to
me. Is there a site I can go to to get simple, practical information about
this? I currently am using the Link Table Manager to update the links to the
BE and the 2nd FE every time I copy my FE from one PC to another but it gets
tedious. I have seen code that performs this function but now cannot find
said code. I am looking for a way to automate the process. Any info you can
send my way would be helpful.
 
Actually, you can do it from Link Table Manager.

Instead of using the "share" when you select where the back-end is located,
use Network Neighborhood and navigate to the server name (\\servername),
then to the highest level folder/directory (\firstlevel), then to the next,
etc., until you finally can point at the file (xxxx.mdb). When you've done
it this way, your linked tables will show as:

tblYourLinkedTable(\\servername\firstlevel\...\xxxx.mdb)

instead of:

tblYourLinkedTable(R:\YourFolder\...\xxxx.mdb) -- your "share" may not
be "R:"
 
Back
Top