Password protect individual Reports or Queries?

Hi,

We cannot password protect those reports or queries.

However, what you can do is to create the following:

1) User and Group Account
This is where you create user and group account with passwords

2) User and Group permissions
This is where you set who should read, have editing powers ect...

You can also select which files.

All the above is accessible from Secury from "Tool Menu"

I hope that helps.

let me if that answer your question

Phil

"Pazlia" wrote in message
...
Access 2002 - Is it possible to password protect invidiual Reports or
Queries. We don't want all staff to be able to read confidential info.

Access 2002 - Is it possible to password protect invidiual Reports or
Queries. We don't want all staff to be able to read confidential info.

You can create a custom input box with a textbox (set the input mask of the
textbox to a password) and a button then in the click event procedure of the
button you can check for the password in the textbox and if it is not correct
you can cancel the open.

"Pazlia" wrote:

Access 2002 - Is it possible to password protect invidiual Reports or
Queries. We don't want all staff to be able to read confidential info.

I am not that familiar with the access code, what would I put in the click
event procedure as far as code goes in order to check for the password in the
textbox and if it is not correct you can cancel the open ? Thank you very much





"David Widener" wrote:

You can create a custom input box with a textbox (set the input mask of the
textbox to a password) and a button then in the click event procedure of the
button you can check for the password in the textbox and if it is not correct
you can cancel the open.

"Pazlia" wrote:

Access 2002 - Is it possible to password protect invidiual Reports or
Queries. We don't want all staff to be able to read confidential info.

Do a search. This is asked and answered often. You should find previous
posts that contain links to specific examples on the web.



"STP" wrote in message
...
I am not that familiar with the access code, what would I put in the click
event procedure as far as code goes in order to check for the password in
the
textbox and if it is not correct you can cancel the open ? Thank you very
much





"David Widener" wrote:

You can create a custom input box with a textbox (set the input mask of
the
textbox to a password) and a button then in the click event procedure of
the
button you can check for the password in the textbox and if it is not
correct
you can cancel the open.

"Pazlia" wrote:

Access 2002 - Is it possible to password protect invidiual Reports or
Queries. We don't want all staff to be able to read confidential
info.