Call Link Table Manager windows from VBA

[SF]

Hi,

I have a database put in the shared drive with front end (on user PC) link
to it. Now several users wnat to have a copy of the backend on their laptop
so that they can refer to the infomation on the database while working in
the field.

I thought to allow them to copy the backend mdb to their laptop and allow
them to relink tables but I cannot find a way to call the Link Table Manager
since the menu bar is disable. Is there a way to call Link Table Manager
from VBA?

SF

 

[SteveM]

You would be better to implement some re-linking code.
This code will check for the DB on the network share and auto re-link to a
common folder on each laptop if not present.

You can try a Google for 'Access auto re-link' or look in the code library
on mdbmakers.com

I did this for someone a while back. I'll have a look for the code and post
it if I can find it.

Steve

 

[SteveM]

Try the link below. You can download an example LinkTest.zip that I did for
someone.

http://www.mdbmakers.com/forums/showpost.php?p=107234&postcount=10

Steve

 

[Tony Toews [MVP]]

I thought to allow them to copy the backend mdb to their laptop and allow
them to relink tables but I cannot find a way to call the Link Table Manager
since the menu bar is disable. Is there a way to call Link Table Manager
from VBA?

No. Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Peter Hibbs]

Have a look at :-

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

which should do what you want.

Peter Hibbs.