Prev: Set focus
Next: create a form that collects parameters
From: aw on 3 Jun 2010 21:53
We have three groups of user that will use our database. Administrator (my
boss & me), PowerUser (Manager / Supervisor) & NormalUser (clerk)

Now, my front-end .accde will open my designed form – (main menu1) without
any control.


What we are planning are :

1. Users should have input their password (user can change by themselves)
before they can login into the main menu.
2. Different class of user can open their own menu only (eg. Poweruser will
open Frm_MainMenu1 & NormalUser will open Frm_MainMenu2 …) that depend on
what password they input

Could you give me some hints for doing this

Thx!

--
aw
From: Tom van Stiphout on 4 Jun 2010 02:01
On Thu, 3 Jun 2010 18:53:04 -0700, aw <aw(a)discussions.microsoft.com>
wrote:

If you're on a Domain, this article of mine may help:
http://www.accesssecurityblog.com/post/Securing-Access-databases-using-Active-Directory.aspx

You could indeed open a role-specific menu form, but I would rather
use a single form and suppress some menu items that are not
appropriate. This cuts back on alpha testing and beta testing time.

-Tom.
Microsoft Access MVP


>We have three groups of user that will use our database. Administrator (my
>boss & me), PowerUser (Manager / Supervisor) & NormalUser (clerk)
>
>Now, my front-end .accde will open my designed form � (main menu1) without
>any control.
>
>
>What we are planning are :
>
>1. Users should have input their password (user can change by themselves)
>before they can login into the main menu.
>2. Different class of user can open their own menu only (eg. Poweruser will
>open Frm_MainMenu1 & NormalUser will open Frm_MainMenu2 �) that depend on
>what password they input
>
>Could you give me some hints for doing this
>
>Thx!
 | 
Pages: 1
Prev: Set focus
Next: create a form that collects parameters