linked table manager

[arista via AccessMonster.com]

Is there some easy way how to open a Linked Table Manager from the running
application ? I restricted menu which also contains "Tools -> Database
Utilities -> Linked Table Manager". It would be nice to open Linked Table
Manager by click on some button. Is there something like : DoCmd.Open
LinkedTableManager ?

 

[Douglas J. Steele]

How about replacing the Linked Table Manager with your own custom code? (I
personally don't find the LTM particularly user-friendly, especially as you
can't always see the full path to the linked databases)

See http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" for
one approach.

 

[arista via AccessMonster.com]

Hi
we are using Access 2003 and we have not found problems with Linked Table
Manager. So I would like to use it. Is there some option how to run the menu
command from the VBA code ?
Thanks

 

[arista via AccessMonster.com]

OK, I found it - it is the command:

DoCmd.RunCommand acCmdLinkedTableManager

 

[Douglas J. Steele]

Try

DoCmd.RunCommand acCmdLinkedTableManager

(introduced in Access 2002)

I still think you're far better off having your own code, rather than
relying on the LTM, but it's your application.