By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Programatically accessing "object groups"

P: n/a
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

Jan 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<j.******@computer.org> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
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


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"
Jan 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.