Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Customerlized Security Control in Access 1.1 or 2.0

3 views
Skip to first unread message

820077@oes

unread,
Jun 27, 1994, 5:20:02 AM6/27/94
to
Hi! Everybody!

I have a problem about designing a customerlized security control.

As we know, in Access 1.1, the PIM.MDB use a table to maintain the users and
their passwords. But is it possible to add security to the table ? (I mean I
don't need to add one user one step by one step, I just need to assign "group"
to them, then, they automatically have the limitation!) If "Jeff" belongs to
the group of "user", then Jeff has every rights which belongs to "user".

In PIM.MDB's example, this system only control whether the users have the
right to open the first form (the main form!)!!!


THANKS A LOT! I NEED YOUR ADVICE!!!


Vicki Wang
vick...@oes.itri.org.tw

Rudy Widjaja

unread,
Jun 27, 1994, 3:13:36 AM6/27/94
to
In article <820077.64.2E0E99C2@oes> 820077@oes writes:
>Subject: Customerlized Security Control in Access 1.1 or 2.0
>From: 820077@oes
>Date: Mon, 27 Jun 1994 09:20:02 GMT
>Keywords: Security Control, Access

>Hi! Everybody!


>Vicki Wang
>vick...@oes.itri.org.tw

create a security in the sytem.mda (which is ms access security)
you can assign a user / group to what ever you want it to be.
like a viewing group, editing group, executing group. etc.
and then you create a user + password then assign them to the group.

/--------------------------------------------------\
| Rudy Widjaja | Contractor |
| Widjaja...@lilly.com | Eli Lilly and Company |
\--------------------------------------------------/
Please Don't Send the response to my e-mail yet.
Because we are still having problem in receiving
e-mail. you can call me at 317-277-3015

820077@oes

unread,
Jun 27, 1994, 8:57:44 AM6/27/94
to
In article <Widjaja_Rudy_...@lilly.com> Widjaja...@lilly.com (Rudy Widjaja) writes:
>Subject: Re: Customerlized Security Control in Access 1.1 or 2.0
>From: Widjaja...@lilly.com (Rudy Widjaja)
>Date: Mon, 27 Jun 1994 07:13:36
>Keywords: Security Control, Access

>>Hi! Everybody!


>>Vicki Wang
>>vick...@oes.itri.org.tw


This is the way I do before, but evertime when a new user added, I must go
through every forms, tables, queries, reports, modules, and macros. Is it
possible to do like what PIM.MDB do? Use a table to control it ?

Rudy Widjaja

unread,
Jun 27, 1994, 3:06:46 PM6/27/94
to
well yes you can use like in the pim.
like you can assign the password + user in the table and maintained + maybe
you also want to create a group field so you can assign the grouping.
0 new messages