Programatically accessing "object groups"

[j.eckles@computer.org]

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 programmaticall y 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

[Anthony England]

Re: Programatically accessing "object groups"

<j.eckles@compu ter.org> wrote in message
news:1136328573 .490401.14420@o 13g2000cwo.goog legroups.com...[color=blue]
> 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 programmaticall y 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[/color]



This is what I put into the Google Groups search page:
"database window" objects groups favorites
All answers (some by very experienced Access folk) seem to point to the
answer:

"Abandon all hope of doing anything with these - they are not accessable in
any way apart from the Access UI which is provided"