Password protection

[Guest]

I know there is a way to password protect an entire form, but is there any
way that I can password protect just one particular field [datereceived] in a
form frmNewfile, so that when an attempt is made to enter or change the data
in [datereceived], the user is prompted for a password before the entry can
be made?

Best I can figure is to put all such fields on one form and password protect
the form, but I would rather not do it this way if possible.

Thanks.

 

[Guest]

I don't know of any way to do that offhand, but can think of a round about
way to do it. I am sure there are others on here that can think of better
ways to do this.

Field getfocus ()
if vrbPassword = false then 'the password has not been entered yet
open password_entry form
end if

form password_entry ()
'once password has been entered
check to ensure password is correct
if correct then
set vrbPassword = true
end if

Troy

 

[Rick B]

Personally, I'd hate to have password prompts pop up every time I wanted to
make entries in a field.

A better idea is to enable or disable that field based on who is logged on.

Don't make your higher level employees type in secret passwords every time
they try to do something important. Ask for a userid and password once when
you open the database and then set all your access based on that one login.

Also, using the method you mention, what would prevent the user from simply
opening the table, or query and changing the field? Or, what would create
the user from creating their own simple form and including that date field?
Or, what would prevent them from reading your code and seeing the password
there?

Lots more to security than just adding a pop-up prompt and asking for a
password.