Re: Update Links

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

--
Good luck

Jeff Boyce
<Access MVP>

"Kincaid" <Kincaid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:12F8073C-F411-49E4-B8A6-02C1A24F3608@xxxxxxxxxxxxxxxx
> 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.
>
> "Jeff Boyce" wrote:
>
> > 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.
> >
> > --
> > Good luck
> >
> > Jeff Boyce
> > <Access MVP>
> >
> > "Kincaid" <Kincaid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:A8D9148F-5990-4C96-B969-2EAA3A456063@xxxxxxxxxxxxxxxx
> > > 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.
> > > --
> > > kinacid
> >
> >

.

Relevant Pages

  • Re: Create new record from combo box in a form
    ... Date of Hire, Manager, Work Group may apply to a person, but these are NOT ... will be Vacation week Start Date, Vacation Week end date, and and Single ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.formscoding)
  • RE: When IT Manager breaks rules
    ... Why do this manually when you can automate the process via a script or even via built in MS architecture? ... changes, domain policy changes, etc. ... When IT Manager breaks rules ... forcing him to dilute the AD account creation policy. ...
    (Security-Basics)
  • Re: Increasing field size with linked tables
    ... Utilities | Linked Table Manager (exact path may vary, ... > 11 in the field size versus the 16 set for field size at the server. ... >> Good luck ... >> Jeff Boyce ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Cross checking two sources
    ... HRID, Manager name, Division and District. ... "Jeff Boyce" wrote: ... Neither source is absolutely correct. ...
    (microsoft.public.access.queries)
  • Re: Delete messages
    ... >> Marc, ... The easiest way for you to automate this process would be to use ... Look in System Manager. ... and create a new recipient policy/mailbox manager policy. ...
    (microsoft.public.exchange.admin)