Posted: 22 Feb 2010 04:36 AM PST
We have seen this procedure in the Security Main Menu. The UserIDs, PersonalIDs, Work-GroupIDs and Passwords of Users are maintained in the Workgroup Information File (a database with .mdw extension and the Default Workgroup Information File is System.mdw).
Access privileges to Database Objects are stored within the database itself. Both these two parts of the Combination-Lock (UserID with PersonalID in Workgroup Information File and access rights to individual objects for each User/Group maintained within database) works together. Individual User gets access to Objects with the right UserID, Password and PersonalID. PersonalId is a very important element of the User-Profile and we need it again, if we ever need to recreate a Workgroup Information File, when the existing one is corrupted or lost.
UserIDs and GroupIDs can be created and managed only by Administrators (a member of the Admins Group with Administrator privileges) of the Database.
First, let us create a test User Account manually. Go through the following procedure for creating a User Account manually and see how it is done?
Visit the Page: Create MS-Access User-Account for more details.
By default all Users will be members of the Users Group. If the User is going to be part of any other User-Groups then that Group Name must be selected from the Available Groups List and Add it to the Member of list at the right hand side.
Let us see how to create a User-Account with VBA, except the procedure explained for joining the User to a particular Group. We will examine the procedure for joining the User to a Group later, after learning to create a Group Account with VBA.
The following VBA Code creates a User Account with the User Name: SMITHJOHN, with the Personal ID: SJ78901 and with an initial Password: SMITHJOHN:
When we create a User-ID manually we can only set a password for the User after opening a new MS-Access Application window and by going through the Menu Tools- ->Security- ->User and Group Accounts- - > and log-in without a password and select Change Logon Password Tab of the Dialog Control and set a new Password.
The User-Names are in alphabetical order.
We can check for the presence of a particular User Name in the active Workgroup Information File with the following VBA Code:
Type the following in the Debug Window (Immediate Window) and press Enter Key to run the above Code:
If you have not run the first program to create the User Account SMITHJON then to test the second Program, Call the above function with the Admin User Name.
Type the following in the Debug Window (Immediate Window) and press Enter Key:
Form Bookmarks and Data Editing-3
Form Bookmarks and Data Editing-2
Form Bookmarks and Data Editing
Run Slide-show when Form is idle
Filter Function Output in ListBox-2
|You are subscribed to email updates from LEARN MS-ACCESS TIPS AND TRICKS |
To stop receiving these emails, you may unsubscribe now.
|Email delivery powered by Google|
|Google Inc., 20 West Kinzie, Chicago IL USA 60610|