Hidden & System Tables

[Guest]

I have several Access 2003 databases containing tables with the usys prefix
and they are also hidden. I have imported onne of these databases into Access
2007. I cannot find in MS Help any way to show these hidden system "usys"
prefixed tables.

 

[Jeff Conrad]

Hi Malcolm,

1. Right-click the very top of the Navigation Pane.
2. Select Navigation Options from the shortcut menu.
3. In the Navigation Options dialog box look in the Display Options section down in the upper left
corner.
4. Select Show Hidden Objects and Show System Objects to see the system tables.
5. Click OK to save your changes. All the system objects should now appear in the Navigation Pane.

If you want to hide them again, just reverse the steps.

You can also open the Navigation Options dialog box by following these steps:
1. Click the Microsoft Office Button in the upper left corner of the window.
2. Click the Access Options button in the bottom right corner of the Office Menu.
3. Click the Current Database category on the Access Options dialog box.
4. In the Navigation section, click the Navigation Options button.

If you can't find these, post back.

--
Jeff Conrad - Access Junkie - MVP
Co-author, Microsoft Office Access 2007 Inside Out
http://tinyurl.com/3xl4sg
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message:

 

[Guest]

Thanks. I clicked all over the screen and tried Access help. Got nowhere.

MS Help was not of any help in this case.

Again, Thanks