Security Levels for Users

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am building an application for a sales organization.
There are about six sales people and three executives who
want to view reports from this application. I want to
create a main screen which has each of the six reps and a
button and then one executive button. I then want to have
entry to each button password protected. The button take
each rep into their own page where they can run various
sales reports and their accounts. The executives don't
need access to each reps page. They get access to the
overall sale report data.

What is the best way to do the security here? I read the
part about security levels but am confused. Each rep
needs their own password which will not be shared with
anyone. The executives can use the same password. A quick
overview of how security works as far as passwords would
be appreciated

Thanks,

Chuck
 
Hi Chuck,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

There are many ways of doing this. A good starting point would be a
Knowledge Base article below that password protects a report in the
Northwind sample database. Instead of using the code in the OnOpen event
of the report, you could use it in the OnClick event of a button and modify
it to open what ever form/report you wanted for each of the users.

http://support.microsoft.com/default.aspx?scid=kb;en-us;209871

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top