Linked Table Manager Problem

[thatlemhome]

I am attempting to put a button for Linked Table Manager into either a custom ribbon or Office Menu, then build the application in runtime.

In building the XML UI ribbon script, I noticed a spelling error(either intentional or not) in the file name "DatabaseLinedTableManager" as reported in the Access Ribbon Controls Spreadsheet from Microsoft. (no k).

The issue is that whereever I define the button (as specified without the k) - either on the ribbon or office menu - I can't open the tab or menu followed by an error, with "send reports to MS" and it closes the application. If I try to type it in with the K into the script I get an error in the script.

My only other option is to add the entire Database tools group - which includes functions such as password controls, build accde files, etc that I don't want the end-user to see. Additionally, the group does not allow you to "hide" the other icon controls within the group - as I get a specific error indicating such when I write it into the script.

It appears to work fine when building with Access 2007, but becomes a problem when packaged in runtime.

I need some serious help with this, as I've been going round and round on this for days, and it's the last serious bug I need to resolve before I push this out. I have also not been able to find any reference to this problem anywhere on the web.

I'm using the latest 2007 runtime application, 12.0.6425.1000
My OS is Windows XP with SP2

Thanks

 

[boblarson]

As far as I know, the linked table manager is not available during runtime as that constitutes a "design change." You would need custom code to do the relink. I suggest you check out this relinking code from MVP Armen Stein.

 

[thatlemhome]

thanks. I see a macro link doesn't work for this either.

Know any good alternatives to runtime?