Create Groups in VBA

[RobCPA]

In Access 2000 and XP give the user the capability to create Groups which can contain links to particular objects such as tables, queries, etc.

Does anyone know if there is a way to copy these objects to groups programmatically using VBA?

 

[scking]

Your question is short and doesn't contain enough information. Access uses forms to create security groups in the workgroup. DAO allows you to programmatically create security objects but copying them would probably be more trouble than it is worth. There are no links from a group to table objects. It would be very non-trivial.

A link is an object in itself and you can programmatically set permissions for any group or single user.

If you want more info please elaborate.



---------------------
scking@arinc.com
---------------------

 

[RobCPA]

Thank you for your response. My question does not relate to Access security at all. If you take a look at the left hand side of the Access screen, there is an Objects box and within that you can select Tables, Queries, Forms, Reports, Pages, Macros and Modules. Directly under that section is a header called Groups with Favorites listed as the initial group. You can create new groups, each with links to various objects (tables, queries, forms, etc).

Access describes the Groups like this:

"You can create special groups in your database to help you organize related tables, queries, forms, reports, data access pages, macros and modules. You can save shortcuts in each of these groups that are pointers to the objects in the group."

I'm just not sure if the VBA is available to copy the links into the various Groups. Currently, in order to copy tables to a particular group, you have to select each one, right click, select Add to Group, then select which group to add it to. I'm wanting to create something that allows the user to copy multiple objects to a Group at a time.