Re: Login Security

From: rideout (mrideout@instlab.com)
Date: 08/12/02 

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

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