setting password

[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

 

[Keith Wilby]

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

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