Making a User Account a Member of a Group with SQL command : Group Account « Access « VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

VBA / Excel / Access / Word » Access » Group Account

Making a User Account a Member of a Group with SQL command

 

Sub AddUserToGroup() 

    Dim conn As ADODB.Connection 



    On Error GoTo ErrorHandler 



    Set conn = CurrentProject.Connection 



    conn.Execute "ADD USER YourName TO YourGroupN" 

ExitHere: 

    If Not conn Is Nothing Then 

        If conn.State = adStateOpen Then conn.Close 

    End If 

    Set conn = Nothing 

    Exit Sub 

ErrorHandler: 

    Debug.Print Err.Number & ":" & Err.Description 

    Resume ExitHere 

End Sub

Related examples in the same category

1.	Creating a Group Account
2.	To create a new group account in the current database
3.	Adding a User to a New Group
4.	Deleting a Group Account
5.	Listing All Group Accounts
6.	Listing Users in Groups
7.	Creating a Group Account with SQL command
8.	Removing a User Account from a Group with SQL command
9.	Deleting a User Account with SQL command
10.	Granting Permissions for Tables to an Existing Group with SQL command
11.	Revoking Security Permissions with SQL command
12.	Deleting a Group Account with SQL command
13.	Add group
14.	Add user to group

java2s.com |

| Contact Us | Privacy Policy

All other trademarks are property of their respective owners.