My application links to an Excel spreadsheet which is from a bank download. Everything works perfectly in Access 2010 including a button calling acCmdLinkedTableManager. For my end users this spreadsheet resides in a variety of locations, hence the need to re-attach in the runtime environment. The button, however, produces no response in runtime and no error indication; just a slight flicker suggesting it is NOT disabled in any way.
Is Linked Table Manager functionality not available in Access 2010 runtime? It certainly was in earlier versions.
Any suggestions or ideas would be welcome.