By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

different permission for different users for password using tables and forms

P: n/a
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

Jan 2 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
what is "the old way"?
I would try to convince your boss to let you do it the right way, which is
with Access' User Level Security. Once you get it set up correctly (which is
not a simple task - it will take you some studying to get it right) then
logging in and having different permissions for different users is easy to
do. "doing it yourself" might be just as much work, but wont be nearly as
secure.
For info on Access' security, check out:
http://support.microsoft.com/default...t%2Fsecfaq.asp

-John
"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

Jan 3 '06 #2

P: n/a
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

Jan 3 '06 #3

P: n/a
On 1 Jan 2006 22:05:45 -0800, "Nerrad" <Ye********@gmail.com> wrote:
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


See http://www.mvps.org/access/api/api0008.htm for retrieving the
network logon name and then set Cancel = True in the form OnOpen event
to stop unauthorised users opening that form.

P
Jan 4 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.