I'm trying to determine if there is a way in VBScript, perhaps via ADO
or DAO, to access what I'll term MS Access "object groups". What I
mean by "object groups" are the folders that you see under the "Groups"
pane on the left hand side of the Access 2003 application, just below
the "Objects" pane. There's always one default Group called
"Favorites". These are also the groups referenced in the "Groups" and
"Add to Group" menu items under the Edit menu in Access 2003.
For further clarification, I'm not talking about DAO Groups as
described in that API, nor am I talking about user groups.
What I'd like to be able to do is programmatically list the groups that
have been defined, and list the objects (queries, tables, etc.) that
are assigned to each group. These groups do not seem to be listed as
objects in the MSysObjects hidden table, nor can I find reference to
them in any other hidden table. There also isn't a Group property or
anything like that in the DAO QueryDef object.
Searching for this information has proven difficult because of the many
meanings of the term "group".
Thanks for any advice you can provide.
Jay Eckles