I have a project tracking database with 3 categories of users. 1 - Project Managers (can update all forms and tables) 2 - Project Viewers (can read all forms, reports and tables) 3 - Project Resources (can read all forms, reports and tables but can only update tasks that they are assigned. If I setup the workgroups through Access, I need to capture who the user is in order to enforce the security regarding the Project Resources. From the log on/password box, how do I determine who the user is?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Implementing Workgroups and Form Security
- Thread starter sms28
- Start date
Check out the Access Security FAQ. It's dense reading, and it will take a few reads to get it all, but it's got just about everything you need to know about Access Security in it. There's a copy on my website.
For this one, the currentuser function will return the username of the person currently logged in.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
For this one, the currentuser function will return the username of the person currently logged in.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Status
Similar threads
- Locked
- Question
