passwords

R

richard

We have a form which displays records that have been entered. To prevent
users changing the data once it has been entered the form is set to
Me.Allowedits=False.
As is always the case there is an however and this is that occasionally
there is a need to alter the details within the record.
So the question is now
Is it possible to have a command button which using Msgbox code prompts the
user for a password, which the users enter and if correct then
Me.Allowedits=True.
If this is not possible then what other methods could I use?

Thanks

Richard
 
R

RBear3

It is possible, but not very secure. If you are doing it to prevent
accidental changes, it would be fine. If you are trying to secure the
feature, then it leaves too many holes.

A better way would be to build a separate "editable" form that only certain
people have access to.

OR, check who is using the database, and only allow certain people to modify
records. Or, Only allow certain users to change the form to modify mode.

In other words, use the built-in user security to verify the user when they
open the database, then grant your permissions off of this. This eliminates
the need to put your password into an "if" statement that your users could
easily view.
 
R

richard

It is only to prevent accidental changes, so could you advise how to create
the msgbox

Thanks
 
Top