Add ability to create/use folder metaphore to Access

[Guest]

Currently I have about 20 update and select type queries for a particular
database, and I know that there will be more added. Additionally, some of
these update queries must be run as a set in a certain sequence as they make
incremental changed to the various tables in my database, i.e.,
update_01_table_x through update_05_table_y. If I were storing these queries
in the operating system I would organize them by their function and put them
queries into seperate subdirectories in a scripts directory, but since they
"live" in Access as queries, I already have the main Query area, but must put
them all together in this one area.

What I want to do is create sub-folders, similar to the OS folders, under
the various tabs. This way I could organize sets of tables, queries, macros,
etc into collections of related "things" as a lower level of granularity than
simply Tables, Queries, or Macros.

Taking this one step further, it would be nice to also be able to store
"doc" or "text" files in these areas, and sub-folders, so I could put
opperating instructions or design docs with their related database objects.

Thank you

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-bedc-4b45e972928c&dg=microsoft.public.access

 

[Guest]

If you look at your main window in Access, there is a bar on the left side
with Objects and Groups listed. If you right-click just below the Group
"Favorites" you will get a menu option of "New Group." You can use the
folder you create to drag items (such as queries, forms, etc.) that you want
to organize. You are just creating a shortcut to that item, but it is a way
of organizing similar items. I don't believe you can drag text files to
those folders.