usys tables in Access 2007

[malcolm]

I have several Access 2003 databases that include some tables with the "usys"
prefix so they are considered system tables. They are also hidden. I have
imported one database with several of these "usys" prefixed tables into
Access 2007 but cannot find a way to unhide them so I can modify their data.
Is there a solution? MS Help has been of little use.

 

[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:

 

[malcolm]

Thanks - I clicked all over the screen and missed it. Nor did MS help
actually help.

I'm waiting for some good books to come out but they all seem to have an
April publishing date.

 

[Marshall Barton]

malcolm wrote:
[]

I'm waiting for some good books to come out but they all seem to have an
April publishing date.

Funny you should say that. Just yesterday, we were
complaining that John and Jeff's book won't be out until
April. ;-)

Maybe we could all get together and force the authors to
write faster about what MS might produce when they finally
get their code to work. Then those lazy publishers have to
do all their editing and such faster so they can finish the
printing and distribution processes in less than two months.
I just don't understand why all these people have to take so
long to do their job <gdrvvvf>