Access should provide folders to group queries and tables

[Guest]

Right now in Access you can create a favorites list to show favorite queries,
tables, forms, etc. But my problem is that often I have my own queries in a
database used by several people that has structural updates every so often.
I can import all of my personal use queries over there, but it would be
helpful if tney were all in one folder so that I could have them as a group.
Right now I have to look through a long list to find them each one by one,
and sometimes I don't remember to get them all.

----------------
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...90b5afd3b4&dg=microsoft.public.access.queries

 

[tina]

you can prefix each of your own queries with a combination of letters (your
initials, perhaps?) so that they're all grouped together in the database
window. or you can create your own "frontend" database to hold all your
personal queries, and link to the tables of the shared database so that you
have access to the data. really, any database that has multiple concurrent
users should be split in this fashion anyway.

hth

Right now in Access you can create a favorites list to show favorite queries,
tables, forms, etc. But my problem is that often I have my own queries in a
database used by several people that has structural updates every so often.
I can import all of my personal use queries over there, but it would be
helpful if tney were all in one folder so that I could have them as a group.
Right now I have to look through a long list to find them each one by one,
and sometimes I don't remember to get them all.

----------------
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...90b5afd3b4&dg=microsoft.public.access.queries

 

[Ken Snell \(MVP\)]

Looks like ACCESS 12 is going to have many new ways to group objects... see
http://blogs.msdn.com/access/archive/2005/11/07/490113.aspx

 

[Duane Hookom]

Do you realize you can create as many groups as you would like?

 

[Van T. Dinh]

In the Database Containers window, the LHS has the "Objects" pane and the
"Groups" pane with one default group "Favorites". You can right-click in
the this pane and select "New Group ... " from the Shortcut Menu to create a
new group.

This feature has been around since Access 2000, IIRC.