Since you know, and have already told the responsible parties (I presume)
that neither Access Security and certainly not a Security Lite (done the
"old way") is likely to do much more than delay anyone who is serious about
breaking in to your database appliecation, feel free to proceed with
Security Lite.
You will need to invent a coding scheme to cover the different permissions
that you allow. You'll need to code the users' ID and their codes in a table
(just to keep an unknowledgeable manager from poking around, start the name
of that table with USys... so it will not show unless "view system tables"
is checked... name it something that does not reek of security, just in case
one of those managers does poke around and see it.
Use the technique and API described in
http://www.mvps.org/access/api/ to
retrieve the user's Windows login, so the user does not have to log in
separately. I believe that technique and API are api0008.htm. If you prefer,
or the management prefers, you can place a password on the Admin user so the
users have to log in via Access security; otherwise, create your own login
form.
As the user enters each form, or before executing a DoCmd.OpenForm, check
this user's permissions against the ones required for the Form and use the
Enabled and Locked properties to prevent changes to those for which the user
only has view permissons.
Larry Linson
Microsoft Access MVP
"Nerrad" <Ye********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
hi guys, i have a project on my hand and what i'm told to do is to
create a log-in feature using tables and forms.
Da question is that is there any way to allow different users different
access to enter into the forms or even to prevent some users from
entering data in certain tables?
I know they have a ms-access security feature but was told i had to do
the old way which is drivin me nuts..
Can anyone help me? Realli do appreciate ur help!
Thanxs lotsa!
Regards