Security for Access

Security for MS Access is provided via a "workgroup" file (by default C:\Program Files\Common Files\System\System.mdw). You can create a new .mdw file for a specific database by opening the database while holding down the Shift key. Then click on TOOLS-SECURITY-USER LEVEL SECURITY WIZARD... This will walk you thru creting a new workgroup file for that specific database. Once you have created the workgroup file, you will need to create Groups using the TOOLS-SECURITY-USER and GROUP ACCOUNTS menu to add users to different groups and use TOOLS-SECURITY-USER and GROUP PERMISSIONS... to set permissions for each user/group. I would encourage you to read the Help files associated with each of these functions before you actually use them.

I tried to use the 'MS Access' security feature but found that this was more trouble than it was worth. What I did instead was to create a login screen with an unbound username and password field. Then I used VB to control these fields and made it so only the users that I listed could gail entry to particular fields. I did however need to create main group pages for the individual groups that I wanted have access to specific pages. If you would like to get an example, email me and I will send you a form with the VB tied to it.