Update Links

K

Kincaid

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.
 
J

Jeff Boyce

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.
 
K

Kincaid

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.
 
J

Jeff Boyce

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:"
 
Top