Code to link external tables

[mattia]

Hi all, can you tell me how can I link external table in my access
application? I want to dinamically select the last updated database and
then populate the tables with this values.

PS Obviously I want to do this in code, the final user shoul only click
"Get updated DB" or something similar.

Thanks, Mattia

 

[Ken Snell [MVP]]

Perhaps you can use the code at this web page as a starting point, and
modify it for your needs?

ChangeLinkPath
http://www.accessmvp.com/KDSnell/VBA_Functions.htm#ChgLinkPth

You'd need to change the code to use a variable instead of a constant as the
path string for the correct backend database file.