Linked Table Manager does not work in 2010 runtime

[OnlyTrevor]

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.

[June7]

Apparently this is a bug or deliberate change for Access 2010. Use code to relink tables with TableDefs collection.

Review
http://www.hitechcoach.com/index.php...split-database
http://forums.aspfree.com/microsoft-...ue-323364.html

[OnlyTrevor]

Many thanks. I've a vague recollection I might have done it this way in the past; I'm a bit rusty but I think I can manage it.