I just upgraded one of my users from MS Office 2003 to 2007 on Windows XP SP3. She was telling me this morning at her office that she has descriptions for all of her Access queries and that in Access 2003 she could see these descriptions alongside the other information about the query, like name, etc. I created a ticket for this issue, and to get her request into written form for the ticket, I googled "can't see query descriptions in access 2007" and found the following post in a forum (See "FORUM POST I FOUND"). I sent this to her and she agreed that it accurately described the problem, but added some comments (see "MY USER'S ADDITIONAL COMMENTS").
My user said that our DBA (who is on vacation right now so I can't talk to her) posted the question on her Access listserv and some DBAs said they could see it the way my user wanted in Access 2007 and others said they could not, but no one seems to know how to get Access 2007 to get it that way. Therefore my question to this group.
FORUM POST I FOUND
In Access 2000/03 I could sort and view my list of queries by the description, which was entered through a dialog box for each query. I cannot find the settings for Nagivation pane that allow me to see the description and sort by like I did in the database window in Access 2000/03..
MY USER'S ADDITIONAL COMMENTS
I think that's an accurate description of the problem. I would add that in Access 2003, query filename, create date, modify date, and description were arranged horizontally and you could sort with a single click on the column header. In Access 2007, they have replaced that arrangement with a left frame (aka the Navigation pane). Create dates, modified dates (and descriptions if they appear), are listed beneath the query filename. To sort, one has to right click on the header for the query list, then click on the sort order desired.