Assigning passwords to the report

P

Purnima Sharma

I want to assign a password to the report so that the user can open his/her
own report only. Can someone help. Thanks !
Purnima
 
R

Rick B

Assigning a password won't really help run the report only for a particular
person unless you build one report for each.

A better way is to setup User-Level Security. This forces each user to sign
on when he opens the database.

Then just include a filter in your report or a criteria in the query to only
allow them to see records for their userid.

This is a pretty common issue. Do a search and look for previous posts with
the following text...

"run with owner"
"RWOP"
"=CurrentUser()"
"only their records"
 
P

Purnima Sharma

Infact, the reports I made are for particularl person only. I have created
separate reports for the Director of Sales, Processing, and Closing. I have
to create passwords for these three individuals so that they can view their
own department's reports only. Thanks!
Purnima
 
R

Rick B

I would simply implement User-Level Security and then give them the
appropriate permissions, if it were me.
 
D

Duncan Bachen

Rick said:
I would simply implement User-Level Security and then give them the
appropriate permissions, if it were me.

You could also split your front-end and backend, and have each of the
employees have different front ends with only their reports in it.

Simplier, but not as secure obviously.
 
Top