A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

User Logins - Restricting Buttons/Forms



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old December 28th, 2006, 07:12 PM
Jeff Monroe Jeff Monroe is offline
Member
 
First recorded activity by OfficeFrustration: May 2006
Location: San Diego, CA
Posts: 27
Default User Logins - Restricting Buttons/Forms

Hello:

I am creating a mutli-user database and need help with controlling access to forms and buttons based on the user's profile. First of all, I am not using the built-in security wizard (mdw). I'd prefer not to mess with it. This is a pretty simmple database and I'm not worried about anyone hacking into it.

I have a table (tblEmployees) with three fields: [LoginName], [Password], and [AceesLevel]. When launched, the user enters in their LoginName (via combo-box) and enters their password which gives them access to the database.

Here is what I am attempting:

I would like to restrict certain forms and buttons depending on the AccessLevel (admin, user, viewer)assigned to the user logging in (as per the tblEmployees.AccessLevel). I've been able to do that based on their LoginName, but I'd rather base it on the three (or possibly more) levels, but not for an infinite number of LoginNames. Admin would have full access; User would have everything but Admin privileges, and Viewer can just view.

Specifically, I want to create an "Employee Profile" form that will let the logged in user edit their profile information (password, extension, etc), but not view any other's, and of course Admin can view and edit them all.

Thanks to anyone who responds.

jwmonroe
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.