Open the Linked Table Manager from Button (?)

[croy]

Is there a way to open the Linked Table Manager from a
button click?

 

[Marshall Barton]

Is there a way to open the Linked Table Manager from a
button click?

DoCmd.RunCommand acCmdLinkedTableManager

Even if that does what you ask, you should never expose thw
link table manager to users. If they are not experts in
linking tables, they can make a serious mess of things.

Way better for you to use code to do the (re)linking based
on a user selected file path. To select file/path see:
http://www.mvps.org/access/api/api0001.htm

Then to relink the tables to a single db, you could use the
code in this article:
http://www.mvps.org/access/tables/tbl0009.htm
Or, especially if the table are in more than one db, these
articles:
http://dfenton.com/DFA/download/Access/Reconnect.html
http://www.mvps.org/access/tables/tbl0012.htm

 

[Daryl S]

Croy -

Put this in the code for the button:

DoCmd.RunCommand acCmdLinkedTableManager

 

[croy]

Even if that does what you ask, you should never expose thw
link table manager to users. If they are not experts in
linking tables, they can make a serious mess of things.

I certainly appreciate that thought, but the only other user
for this db is my boss, and he wants it there! ;-)

Way better for you to use code to do the (re)linking based
on a user selected file path. To select file/path see:
http://www.mvps.org/access/api/api0001.htm

Then to relink the tables to a single db, you could use the
code in this article:
http://www.mvps.org/access/tables/tbl0009.htm
Or, especially if the table are in more than one db, these
articles:
http://dfenton.com/DFA/download/Access/Reconnect.html
http://www.mvps.org/access/tables/tbl0012.htm

Thanks. I'll keep that info on hand.

 

[croy]

Croy -

Put this in the code for the button:

DoCmd.RunCommand acCmdLinkedTableManager

Thanks Daryl! I never thought of that syntax.