ACC: How to Add a User to a Group with CreateUser Method

MORE INFORMATION

1. Create a module and type the following procedure:
   
   NOTE: In the following sample code, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when re-creating this code Access Basic.

         Function CUser (uname As String, upin As String, upwd As String,_
          gname As String)
            Dim u  As User, w As WorkSpace, g As Group
            Set w = dbengine.workspaces(0)          'The default workspace.
            Set u = w.CreateUser(uname, upin, upwd) 'Create a user for the
                                                    'Access session.
            w.users.Append u                        'Add user to workspace.
            w.users.Refresh
            Set g = w.groups(gname)
            Set u = g.CreateUser(uname)             'Create a user for a
                                                     group.
            g.users.Append u                        'Add new user to group.
            g.users.Refresh
         End Function
   						

2. To test this function, type the following line in the Debug window (or the Immediate window in version 2.0), and then press ENTER:

   ? CUser ("MyName","1234","MyName","Users")

3. On the Tools menu point to Security, and then click User And Group Permissions.
   
   NOTE: In version 2.0, on the Security menu, click Permissions.
   
   Note that the new user appears in the Users/Group Name box.