asked on

Files missing from Access 2007 database Navigation Pane

Hi Experts,

I have a MS Access 2007 database and I have suddenly realized that several local Access tables are missing from the navigation pane window (I think that is the name of the window).
The files obvously still exist because they are being used in drop-down controls and in other ways just fine. "Show hidden files" is checked, as is "Show system objects". I don't know how long these files have been missing from the Navigation window, and the database has been in production for several years now.

I now have a need to modify the tables, but have no way to access them.

What is the story, do you think?

Thanks!

GLFord

Dale Fye

What are the names of the tables?

If the tables are prefixed with "uSys" they will not show up in the navigation pane unless you click the ShowSystemObjects.

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim Dettman (EE MVE)

Note that you can to:

' Show the table
Application.SetHiddenAttribute acTable, "YourTableName", False

To un-hide it if it is hidden.

Jim.

SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Glenn Ford

ASKER

You all win! This was what we call here at work a PICNIC problem. (Problem In Chair, Not In Computer). My mistake. I was looking at a field name and mistaking it for a table name!!!!!!! Arrrrrgh! Gotta review my naming conventions. But, I did learn some things from your postings, if ever a file should REALLY go misssing!. Thank you very much.