Connecting Tech Pros Worldwide Forums | Help | Site Map

Programatically accessing "object groups"

j.eckles@computer.org
Guest
 
Posts: n/a
#1: Jan 3 '06
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

Anthony England
Guest
 
Posts: n/a
#2: Jan 3 '06

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"


Closed Thread