Linked Table Manager

[Rob Parker]

I'm opening the Linked Table Manager with the following line of code:

DoCmd.RunCommand acCmdLinkedTableManager

Works fine. But what I would like to do is also set the checkboxes in the
LTM dialog box - select all the linked tables, and check the "Prompt for new
location" checkbox - via code. Is this possible? If so, how?

TIA,

Rob

 

[Rob Parker]

Thanks Daniel,

I am aware of that code - in fact I use it in several of my applications.
However, I want to use the LTM in one particular case, where the linked
tables are to specific sheets in an .xls workbook. So, do you (or anyone
else reading this) happen to know the answer to my original question(s),
rather than a work-around?

Rob

 

[Douglas J. Steele]

I don't believe it's possible to automate the Linked Table Manager.

You're far better off writing your own routine.

 

[Rob Parker]

Thanks Doug,

I'll go that way.

Rob

I don't believe it's possible to automate the Linked Table Manager.

You're far better off writing your own routine.

 

[HiTechCoach via AccessMonster.com]

I prefer to use VBA code so tht I have complete control.

Check out:

http://www.mvps.org/access/tables/tbl0009.htm