| re: Programatically accessing "object groups"
<j.eckles@computer.org> wrote in message
news:1136328573.490401.14420@o13g2000cwo.googlegro ups.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 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[/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" |