Allowing only certain users to view design and code

[Guest]

I accidentally posted this question on the Install and Configure post but got
no answers so I am going to post it here:
I created a login form that checks for matching values (usernm and password)
on tblpassword to allow users to enter the database. The database menu
(which always remains open) records the usernm value. Additionally, I have
another form, frmPermissions, which contains a usernm drop-down menu
(corresponding the usernm on tblpassword) and check boxes corresponding to
the forms on the database. If a box is checked it means that the user is
able to access that particular form. Now, I would like to add something on
that form that would allow (or forbid) users to view/edit design and code.
How can I go about doing this? Thanks, for any help!

 

[Rick Brandt]

I accidentally posted this question on the Install and Configure post
but got no answers so I am going to post it here:
I created a login form that checks for matching values (usernm and
password) on tblpassword to allow users to enter the database. The
database menu (which always remains open) records the usernm value.
Additionally, I have another form, frmPermissions, which contains a
usernm drop-down menu (corresponding the usernm on tblpassword) and
check boxes corresponding to the forms on the database. If a box is
checked it means that the user is able to access that particular
form. Now, I would like to add something on that form that would
allow (or forbid) users to view/edit design and code. How can I go
about doing this? Thanks, for any help!

Why aren't you using the built in security? These "home grown" types of
security systems are only good for "guiding clerks". Anyone having more than a
casual familiarity with Access can circumvent your security in a matter of
seconds. Beyond that you should be supplying users with an MDE copy of your
file which doesn't allow most design changes anyway.