1

In an Access file the "Linked Table Manager" is missing in Office 2010, in fact the only menus are File and Home are visible. How do I unhide the Linked Table Manager so I can fix the location of the associated database? The menu does not hide for any other accdb files, just this one in particular.

enter image description here

enter image description here

3 Answers 3

2

The answer was Privacy Options, not "Options". It's critical that people answer questions accurately...though it would certainly help if corporations like Microsoft didn't keep redesigning the GUI of their software every two years purely for the sake of change.


  • Go to File / Privacy Options.
  • Click on Current Database on the left panel menu.
  • Scroll down to the header Ribbon and Toolbar Options.
  • Ensure both options, Allow Full Menus and Allow Default Shortcut Menus, are checked.
3
  • Can you explain in more detail what steps you performed in "Privacy Options". You've marked this as the answer to your question, but there is not enough details for the next person with the same problem to resolve.
    – Sun
    Nov 9, 2014 at 3:43
  • @sunk818 Done. :-)
    – user312854
    Nov 9, 2014 at 7:21
  • I guess it could be useful to hide the menus in certain circumstances though it totally threw us off because we were dealing with someone else's mess. Unfortunately I do not know how similar, if even available, these options are and are accessible in other versions of Access since Microsoft loves to change the GUI at every change. I hope this helps others because it drove us insane.
    – user312854
    Nov 9, 2014 at 7:28
0

Since this is just a ACCDB not an encrypted ACCDE, you should be able to customize your ribbon to bring up the External Tools ribbon as part of the Main Tab:

  • Go to File, Options, Customize Ribbon
  • Navigate to External Data
  • Click Add to have it show on the right side

enter image description here

If you correctly added External Data to the right side, it should appear as a ribbon option:

enter image description here

2
  • Thanks, unfortunately I can not access the options menu. I've updated the question with partial screenshots to show you what I do have access to.
    – user312854
    Oct 28, 2014 at 16:44
  • You could try creating a blank database, then import the tables to it. That should copy the data without the Access interface restrictions.
    – Sun
    Oct 28, 2014 at 16:46
0

The menu does not hide for any other accdb files, just this one in particular.

Check the file extension of the troublesome database file. If the file extension is .accdr then Access will open it with the same settings as the Microsoft Access Runtime. To restore the normal Access menus for this file simply rename it to have the .accdb extension.

You must log in to answer this question.