MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

Users

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

User session class	Custom class containing functions & properties for working with Access & domain user information. Note: Copy this code to a class module.
Limit the number of users in a Jet database	Function for limiting the number of user connections allowable in a database, using Jet OLEDB:Connection Control.
Enumerate all users and groups	Enumerate all the users and security groups
Enumerate the users belonging to a specific group	Enumerate all the users belonging to a specific security group
Enumerate the groups a specific user belongs to	Enumerate all the groups to which a specific user belongs
Create a group	Create a new security group
Delete a group	Delete a security group
Create a user	Create a new user account
Delete a user	Delete a user account
Add a group to a user	Add a user to a specific security group by appending the group to the user's Groups collection
Add a user to a group	Add a user to a specific security group by appending the user to the group's Users collection
Remove a user from a group	Remove a user from a specific security group
Determine if a user belongs to a specific group	Determine if a user is a member of a specific security group
Change a user's password	Change a Jet user's password
Who's on	Code to list the users currently connected to a Jet database