setting password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a database for commissions in our department based on sales. How
can I set up security so that a person can see only his own commission but
not other people's commission. How do I set up password for people
individually? Thanks.

Purnima Sharma
 
Purnima Sharma said:
I have made a database for commissions in our department based on sales.
How
can I set up security so that a person can see only his own commission but
not other people's commission. How do I set up password for people
individually? Thanks.

Purnima Sharma
Click to expand...

You need to do two things, neither of which are two minute jobs:

1 - read and digest the MS FAQ on user-level security. Once you have
mastered this and set up user accounts you can ...
2 - set up your app such that it stores the user name of each record's
creator, thus you can filter on this data in your form's open event so that
only the current user's records are displayed.

There's a link to the FAQ on my website along with a step-by-step example.

HTH - Keith.
www.keithwilby.com
 
Back
Top