Open the Linked Table Manager from Button (?)

  • Thread starter Thread starter croy
  • Start date Start date
croy said:
Is there a way to open the Linked Table Manager from a
button click?
Click to expand...


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
 
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.
Click to expand...


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
Click to expand...


Thanks. I'll keep that info on hand.
 
Back
Top