passwords to open a report

[Guest]

How do I assign a password to open a report (in the same way you assign a
password to open a database)? I have designed individual reports for
directors of various departments. When a person opens a report it should ask
for the password, so that he can view report related to his department only.
Thanks for your help.
Purnima

 

[Rick B]

The best way to do this is to secure your database and only give them access
to the reports they should use. Why make them enter passwords every time
they want to do something? Just have them log in once when they open the
file and then only let them use the objects that they should be using.

If you do build a password like you suggest, there are lots of ways to get
around it. For one thing, the users could simply open the tables and see
the data. Depending on your current security, most users could also create
their own report or query, or simply open a new database and then link to
it.

If you want to do it right, you will have to properly secure the file, deny
access to the tables and queries. Build queries to run with owner
permission, etc.

For more details on either method, do a search and you should find tons of
posts on the topic. To properly secure your database, search for the
keywords "RWOP" or "ONLY THEIR RECORD" or "SECURE RECORDS".

 

[Guest]

Hi Rick,
Thanks for the reply. I know that is the best way to secure the database,
however, my management wants it that way only. I have designed a Switchboard
where I have put all these reports. So, every director's name (there are six
of them) would be on the switchborad. If a person clicks on his report, It
should ask for the password, so that he can see only his report. I looked
under the topics you mentioned, but they don't tell me how to achieve that.
Thanks four help.