NT Domain Security

19 Sep 2007 9:10 PM

mike

We have an access front end that is connecting to a SQL backend. Th
backend is currently using domain authentication and that is working
fine.

What we want to implement is to use domain authentication to open the
access app. Right now we are using the built in user security, but we
want to change it so that it grabs their logged on user info and
checks against that. If the user they are logged on as does not have
permission to run that app, they are denied access or prompted for a
user/pass.

Is this possible?

20 Sep 2007 2:14 PM

Tom van Stiphout

On Wed, 19 Sep 2007 14:10:13 -0700, m***@mcarlson.net wrote:

Yes, but you will have to write some code.
You could use LDAP to check with Active Directory to see if the
Windows User is a member of a certain security group.

-Tom.

Show quote

>We have an access front end that is connecting to a SQL backend. Th
>backend is currently using domain authentication and that is working
>fine.
>
>What we want to implement is to use domain authentication to open the
>access app. Right now we are using the built in user security, but we
>want to change it so that it grabs their logged on user info and
>checks against that. If the user they are logged on as does not have
>permission to run that app, they are denied access or prompted for a
>user/pass.
>
>Is this possible?