VBA: Access: Calling Linked Table Manager

=========
QUESTION
———
Can you call or open the Linked Table Manager in Microsoft Access from your VBA code?

 

=========
ANSWER
———
See EXAMPLES

———
Another interesting way of doing this would be to simply execute a query in your VBA code against each linked table in your database, thereby causing the logon prompt to come up for each one in turn.
As it sits inthe example below though, all you have to do then once the Linked Table Manager pops up is hit Alt+S, then Enter and everything gets re-linked as well.
Your choice!

 

=========
EXAMPLES
———
Private Sub UpdateLinkedTables_Click()

    RunCommand acCmdLinkedTableManager

End Sub 

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
Linked Tables
Linked Table Manager
VBA
ReLink Tables
Re Link Tables
Link Tables

 

=========
REF
———

 


http://www.anysitesupport.com/vba-access-calling-linked-table-manager/
http://anySiteHosting.com

By | 2017-12-01T23:47:41+00:00 June 15th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments