"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
|
Category:
|
Database : Access/Jet
|
|
Description:
|
Microsoft Access Jet databases and their objects (MDB and ACCDB database formats)
|
Module: modJetSecurity
Manage Jet security users and groups in a specified database.
Each of the procedures in this module require that you pass a workgroup name to identify the workgroup you want to work with.
By default, Visual Basic doesn't open a workgroup information file (*.MDA, *.MDW) unless you specify the SystemDB property of the DAO DBEngine object.
When you specify a value for this property, the default DAO Workspace object, also known as Workspaces(0) is mapped to the workgroup information file you specify.
In such a case, specifying a blank value for the strWorkgroup parameter of the procedures in this module effectively uses whatever workgroup information file you are currently using.
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modJetSecurity module
|
|
AddGroup
|
Procedure
|
Adds the named group to the named workgroup.
You must have administrator permissions on the workgroup information file to add a group.
|
|
AddUser
|
Procedure
|
Adds a new user.
Every user must belong to at least one group. Therefore, when you create a user, you must specify an initial group for the user to join by specifying a value for the strGroup parameter.
You must have administrator permissions on the workgroup information file to add a group.
|
|
AddUserToGroup
|
Procedure
|
Adds an existing user to an existing group
|
|
CanUserCreateObject
|
Procedure
|
Determines if the named user can create an object of the specified type
|
|
ChangeUserPassword
|
Procedure
|
Changes the named user's password
|
|
DropGroup
|
Procedure
|
Deletes the named group from the workgroup
|
|
DropUser
|
Procedure
|
Deletes the named user from the workgroup
|
|
GetOwner
|
Procedure
|
Returns the owner of the specified object
|
|
GroupExists
|
Procedure
|
Determines if the named group exists
|
|
GroupsToArray
|
Procedure
|
Populates the passed array with a list of groups
|
|
GroupsToString
|
Procedure
|
Populates the passed string with a list of groups
|
|
IsUserMemberOfAdmins
|
Procedure
|
Determines if the named user is a member of the admins group
|
|
IsUserMemberOfGroup
|
Procedure
|
Determines if the named user is a member of the specified group
|
|
UserHasPassword
|
Procedure
|
Determines if the named user has a password set
|
|
UserHasPermission
|
Procedure
|
Determines if the specified user has explicit permissions to the specified object
|
|
UsersInGroupToArray
|
Procedure
|
Populates the passed array with a list of users
|
|
UsersInGroupToString
|
Procedure
|
Populates the passed string with a list of users
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
