Can you call or open the Linked Table Manager in Microsoft Access from your VBA code?
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.
Private Sub UpdateLinkedTables_Click()
APPLIES TO / KEY WORDS
Linked Table Manager
Re Link Tables