Allowing only certain users to view design and code

2 Jul 2006 4:42 AM

eileenjess

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!

2 Jul 2006 12:47 PM

Rick Brandt

eileenjess wrote:

> 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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com