Auto update link tables

[Guest]

I have a split database, and I need to send the database to a sister office
in another state, because they cannot get fast enough response on the
network. I have no idea what their disk layout is, but I would like to put
the BE on a server and have the FE loaded on individual machines (via copies
of a master). But how do I globally change the link table list in the FE to
point to whatever their path is for the BE, so they don't have to change 30
pointers by hand?
Thanks in advance.

 

[Peter Hibbs]

Have a look at

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

HTH

Peter Hibbs.

 

[Guest]

Dear Peter:

I would very much like to read the article that you are trying to point us
to. However, the link does not work. Can you please give us the location of
the article in Roger's Access Library or give us a working link? Thanks.

 

[Peter Hibbs]

Nicole

Sorry for the delay, I missed your reply.

I clicked on the link I gave and it worked OK, perhaps the link wasn't
working when you tried it. If it still doesn't work try this one and
then look for my name in the list.

http://www.rogersaccesslibrary.com/OtherLibraries.asp

HTH

Peter Hibbs.