Linked Tables

[juneau730]

Good day all,
I have not been figure it out, if it is even possible, but can you make a CMD button in Access, that can be used to relink a table, back to an excel file?

 

[Micron]

Your question is not clear - I have no idea what linking "back to an Excel file" means.
You can relink (refresh) table links via button code.
If you mean link as if you had gone to the ribbon chose External Data > New Data Source > File and chose an Excel sheet to import as a linked table? Then yes to that too.
If you mean execute a saved import specification, yes to that too.

 

[juneau730]

Okay, let me see if I can explain this better.
I am trying to create a CMD button, to launch the Linked Table Manager, to allow the users to relink this table by changing the location of the data source, without them having to go into the Navigation Pane or to navigate thru the menu bar.

 

[Joe4]

Take a look here: VBA: Access: Calling Linked Table Manager - Technology Solutions Provider | anySiteSolutions.com

Then you can attach that code to a button on a Form.

 

[juneau730]

Got it!
Thanks for the help.

 

[Joe4]

You are welcome.