Access Security Options - Access 2003

C

Courtney

I would like to store some information in my database but it is information
which needs to be protected by password so that only specified users can view
and change it. Ideally, I would like to store this information in a subform
within a form which can be accessed by anyone.

Is this possible?

Thank you very much for your willingness to help!
 
G

Golfinray

Go to the subreport or create a subreport. Open the properties of the
subreport. In events find onclick. There will be a box to the right of
onclick. Click it and use code builder. Type the following in where the
cursor is.
Dim stpassword as string
stpassword = inputbox ("enter your password")
If stpassword = "your password" then
docmd.openform "your form name",,, acnormal
else: Msgbox "you entered the wrong password", vbokonly
end if
 
J

John W. Vinson

I would like to store some information in my database but it is information
which needs to be protected by password so that only specified users can view
and change it. Ideally, I would like to store this information in a subform
within a form which can be accessed by anyone.

Is this possible?

Thank you very much for your willingness to help!
Click to expand...

Golfinray's suggestion will help some, but anyone with a modicum of skill in
Access can get past it. "Locks keep out the honest people"!

For a more difficult but more thorough security setup, consider implementing
Access workgroup security. It's available in 2003, but do be aware that it's
been removed from 2007.

Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Study it CAREFULLY. Get a good night's sleep, and study it
*again* even more carefully - it's easy to do security wrong! Follow the steps
on the FAQ, and secure the table containing the privileged data, along with
the subform and query. It will probably be simpler to have separate forms for
the privileged and non-privileged users rather than a subform.
 
Top