Well ...
sub cmdMyButton_Click()
if inputbox ("enter the password") <> "s3cr3t" then
beep
msgbox "no way, jose!"
else
' do stuff.
endif
end sub
If your database was an MDE, the users could not view the code to get the
password.
Of course, this is a >very crude method<, providing no way for authorized
users to change the password (for example). But maybe it would get you
started.
HTH,
TC