SOLVED

Linked Tables Managers not showing 'Delete Link' option

%3CLINGO-SUB%20id%3D%22lingo-sub-1509739%22%20slang%3D%22en-US%22%3ELinked%20Tables%20Managers%20not%20showing%20'Delete%20Link'%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509739%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%C2%B4t%20seem%20to%20delete%20links%20in%20the%20Linked%20Tables%20Manager%20-%20Microsoft%20Access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20couple%20of%20weeks%20ago%2C%20I%20would%20change%20the%20links%20by%20deleting%20the%20existing%20ones%20and%20adding%20a%20new%20when%20I%20needed%20to%20change%20from%20production%20environment%20to%20testing%20environment.%20Now%2C%20when%20I%20click%20Linked%20Tables%20Manager%20in%20my%20db%2C%20the%20option%20%22delete%22%20and%20%22Add%22%20are%20not%20available%20on%20screen.%20What%20changed%3F%20How%20can%20I%20delete%20and%20add%20a%20new%20access%20table%20to%20the%20links%20on%20my%20Access%20DB%3F%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1509739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511664%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20Tables%20Managers%20not%20showing%20'Delete%20Link'%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511664%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722348%22%20target%3D%22_blank%22%3E%40tecmetro%3C%2FA%3E%26nbsp%3BYou%20didn't%20specify%20which%20version%20of%20Access%20you%20are%20using.%20So%20far%20as%20I%20know%2C%20the%20Linked%20Table%20Manager%20has%20not%20included%20an%20option%20to%20add%20or%20delete%20tables%20in%20any%20version%20up%20to%20Access%20365.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20newest%20versions%20of%20Access%20365%2C%20however%2C%20do%20include%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmanage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ean%20enhanced%20Linked%20Table%20Manager%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20what%20happened%20here%20is%20that%20you%20WERE%20working%20with%20the%20newer%20Access%20365%20LTM%2C%20but%20happened%20to%20open%20this%20accdb%20with%20an%20older%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518527%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20Tables%20Managers%20not%20showing%20'Delete%20Link'%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518527%22%20slang%3D%22en-US%22%3EI'm%20using%20Office%20365%20Microsoft%20Access%202013%20(15.0.5119.1000)%2064%20Bits....%3CBR%20%2F%3E%3CBR%20%2F%3EA%20couple%20of%20weeks%20ago%20i%20could%20easily%20change%20the%20linked%20db%20file...%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20my%20current%20version%20doesnt%20have%20the%20enhanced%20version%20of%20the%20Linked%20table%20Manager%2C%20how%20can%20I%20change%20the%20linked%20table%20of%20my%20access%20front%20end%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518708%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20Tables%20Managers%20not%20showing%20'Delete%20Link'%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722348%22%20target%3D%22_blank%22%3E%40tecmetro%3C%2FA%3E%26nbsp%3BYou%20can%20still%20change%20the%20links%2C%20just%20not%20via%20that%20enhanced%20LTM.%20And%20I%20am%20not%20at%20all%20clear%20on%20how%20you%20can%20have%20that%202013%20version%20of%20Access%20with%20the%20enhanced%20LTM.%20I%20suspect%20there's%20a%20bit%20more%20to%20the%20story....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20any%20case%2C%20do%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Selectnewbackend.png%22%20style%3D%22width%3A%20639px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205023i38CEB9FE73A62E39%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Selectnewbackend.png%22%20alt%3D%22Selectnewbackend.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518834%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20Tables%20Managers%20not%20showing%20'Delete%20Link'%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518834%22%20slang%3D%22en-US%22%3EThx!%3CBR%20%2F%3ETurns%20out%20other%20computers%20here%20on%20the%20server%20had%20newer%20versions%20of%20Access%20and%20they%20all%20had%20the%20delete%20and%20add%20option.%20Also%2C%20i%20did%20what%20u%20told%20me%20and%20now%20I%20can%20sucessfully%20change%20the%20linked%20Db.%20Thanks%20man!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518865%22%20slang%3D%22en-US%22%3ERE%3A%20Linked%20Tables%20Managers%20not%20showing%20'Delete%20Link'%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518865%22%20slang%3D%22en-US%22%3ECongratulations%20on%20solving%20the%20problem.%20Continued%20success%20with%20the%20project.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
 

Hello,

 

I can´t seem to delete links in the Linked Tables Manager - Microsoft Access.

 

A couple of weeks ago, I would change the links by deleting the existing ones and adding a new when I needed to change from production environment to testing environment. Now, when I click Linked Tables Manager in my db, the option "delete" and "Add" are not available on screen. What changed? How can I delete and add a new access table to the links on my Access DB?

5 Replies
Highlighted

@tecmetro You didn't specify which version of Access you are using. So far as I know, the Linked Table Manager has not included an option to add or delete tables in any version up to Access 365. 

 

The newest versions of Access 365, however, do include an enhanced Linked Table Manager

 

Perhaps what happened here is that you WERE working with the newer Access 365 LTM, but happened to open this accdb with an older version.

Highlighted
I'm using Office 365 Microsoft Access 2013 (15.0.5119.1000) 64 Bits....

A couple of weeks ago i could easily change the linked db file...

If my current version doesnt have the enhanced version of the Linked table Manager, how can I change the linked table of my access front end?
Highlighted
Best Response confirmed by tecmetro (Occasional Contributor)
Solution

@tecmetro You can still change the links, just not via that enhanced LTM. And I am not at all clear on how you can have that 2013 version of Access with the enhanced LTM. I suspect there's a bit more to the story....

 

In any case, do this:

 

Selectnewbackend.png

Highlighted
Thx!
Turns out other computers here on the server had newer versions of Access and they all had the delete and add option. Also, i did what u told me and now I can sucessfully change the linked Db. Thanks man!
Highlighted
Congratulations on solving the problem. Continued success with the project.