Re: Login Security

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 08/12/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 12 Aug 2002 11:25:25 -0600

IS_MEMBER is a t-sql function that you would call from the
front end by exeucting the sql statement. You can find
examples of it in books online.

-Sue

On Mon, 12 Aug 2002 06:16:34 -0700, "rideout"
<mrideout@instlab.com> wrote:

>What is this T-SQL IS_MEMEBER function about?
>Do i call it from the front using VB or do i use a sql
>statement to so?
>
>I am a little confused on this matter!
>any help would be greatly appreciated.
>
>Thanks,
>Rideout
>>-----Original Message-----
>>You have to write VBA code in the front-end to do so. You
>can retrieve
>>user/group information by executing the T-SQL IS_MEMBER
>function to
>>see if a user is in a group, and the USER function to
>retrieve a
>>database user's name.
>>
>>-- Mary
>>Microsoft Access Developer's Guide to SQL Server
>>http://www.amazon.com/exec/obidos/ASIN/0672319446
>>
>>On Mon, 12 Aug 2002 04:58:57 -0700, "rideout"
>><mrideout@nf.sympatico.ca> wrote:
>>
>>>Hi,
>>>I have a access 2k DATA PROJECT as my front end and my
>>>back end is a SQL Server 2K database.
>>>
>>>Login is done through the back end.
>>>
>>>The problem I am having is that I can't restrict access
>to
>>>buttons on the front end forms.
>>>
>>>How do I restrict these buttons from certain users?
>>>
>>>THANKS IN ADVANCED,
>>>RIDEOUT
>>
>>.
>>