Hi Alf,
I set up a users table with UserID that I save as a database property so each FE can save who it belongs to and offer that as a default. I also store paths to BEs, templates, etc with each UserID
Users are generally categorized by:
1. Admin -- full permissions
2. Data entry with more privileges
3. Data entry
4. Reporting
On the OPEN event of each form or report, I send the form or report object to a routine which figures out who is using the system and if they don't have permission to open the form or report, it is cancelled. the user can be given a message or not.
Then I loop through the controls and set visibility and/or enabled based on user privileges. Sometimes I use the control TAG property to store allowable permissions and sometimes I put them in a table by control. I am getting ready to go to a Windows 8 conference so I don't have time to upload my code to document objects ... oh hey, I already posted it.
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/
Crystal_Doc_Objex_090702__MDB_TXT.zip
this will create tables with all the controls on your forms and reports. Then you can add a column for permissions -- and remove all the columns that you don't need.
Warm Regards,
Crystal
Microsoft MVP, Access
remote training and programming
www.AccessMVP.com/strive4peace
www.YouTube.com/LearnAccessByCrystal
www.YouTube.com/LearnByCrystal
* (: have an awesome day :) *
________________________________
From: Alf <ohmaid@hotmail.co.uk>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, June 1, 2012 6:39 AM
Subject: [MS_AccessPros] Multi Level Login Form
Several years ago, I put together an application which allowed various level access, based on the user login. I now find myself having to replicate the process. Does anyone have any code or similar, which will allow me to bolt on to an existing DB, to save H O U R S of repeating myself.... Please.... Thanks...
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar