Navigation Pane/Unrelated Objects Problem in Access 2007

[jpvonhemel]

My Access 2007 database with one main table. There are associated queries and reports that sort under that table when I have tables and related views checked. The problem I am seeing is some clearly related objects fall under unrelated objects and not with the table. This makes it very cumbersome to stay organized, especially for someone scatterbrained as I am.



Any thoughts or suggestions short of using a custom group and sorting them manually?

Thanks,

Jerold

[Rainlover]

You should be looking at hiding the Nav Pane completely.

Users should only access Forms and Reports through a Menu.

If you give them access as you have they will play with things that they shouldn't and therefore break you Database.

[jpvonhemel]

For an application, yes, but as I am developing queries, tables, and reports, it helps me keep track of databases with multiple objects.