I looked around in the ng but i didn t find a simple answer to this
question
(please, excuse me for my bad english)

i would like to grant access to an access db using active directory
authentication.

eg:
in a pc I have a default login (known by many ppl)
I want only people with a personal login (in active directory) can
access my database without logging out from default login.

is there a way for access to ask for an active directory
authentication when db is opened and grand access only if username/
password are correct ?

many thanks

You can see what ID they're logged in with using code such as that given in
http://www.mvps.org/access/api/api0008.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Francesco" <(E-Mail Removed)> wrote in message
news:95c716d1-bc60-4360-8a74-(E-Mail Removed)...
>I looked around in the ng but i didn t find a simple answer to this
> question
> (please, excuse me for my bad english)
>
> i would like to grant access to an access db using active directory
> authentication.
>
> eg:
> in a pc I have a default login (known by many ppl)
> I want only people with a personal login (in active directory) can
> access my database without logging out from default login.
>
> is there a way for access to ask for an active directory
> authentication when db is opened and grand access only if username/
> password are correct ?
>
> many thanks

On 3 Gen, 18:48, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> You can see what ID they're logged in with using code such as that given inhttp://www.mvps.org/access/api/api0008.htmat "The Access Web"

Yes, thanks I know that.
But I need the authentication.
I want msaccess to authenticate the user for accessing database using
active directory validation...

"Francesco" <(E-Mail Removed)> wrote in message
news:59b8376a-3f50-464e-bc19-(E-Mail Removed)...
> On 3 Gen, 18:48, "Douglas J. Steele"
> <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
>> You can see what ID they're logged in with using code such as that given
>> inhttp://www.mvps.org/access/api/api0008.htmat "The Access Web"
>
> Yes, thanks I know that.
> But I need the authentication.
> I want msaccess to authenticate the user for accessing database using
> active directory validation...

Do you mean you want to challenge them (make them rekey their password)?
Randy Birch has sample code at
http://vbnet.mvps.org/code/network/a...itycontext.htm

Otherwise, please explain what you mean by "authenticate the user ... using
active directory validation". They're already on your network, so they've
presumably already been authenticated.

If you're hoping to integrate active directory with Access user-level
security, hoping to avoid creating user ids and passwords in Access, it
can't be done.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

hey
"Francesco" <(E-Mail Removed)> wrote in message
news:59b8376a-3f50-464e-bc19-(E-Mail Removed)...
> On 3 Gen, 18:48, "Douglas J. Steele"
> <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
>> You can see what ID they're logged in with using code such as that given
>> inhttp://www.mvps.org/access/api/api0008.htmat "The Access Web"
>
> Yes, thanks I know that.
> But I need the authentication.
> I want msaccess to authenticate the user for accessing database using
> active directory validation...

On 5 Gen, 02:31, "abraham ayala ortega" <ayala_su...@hotmail.com>
wrote:
> hey"Francesco" <vi...@tiscali.it> wrote in message
>
> news:59b8376a-3f50-464e-bc19-(E-Mail Removed)...

http://groups.google.com/groups?as_u...oglegroups.com

not found:

"Non trovato

Impossibile trovare il messaggio richiesto 59b8376a-3f50-464e-
bc19-(E-Mail Removed)"

On 4 Gen, 13:53, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

>
> Do you mean you want to challenge them (make them rekey their password)?
> Randy Birch has sample code athttp://vbnet.mvps.org/code/network/acceptsecuritycontext.htm
>
> Otherwise, please explain what you mean by "authenticate the user ... using
> active directory validation". They're already on your network, so they've
> presumably already been authenticated.

users are validated on this pc with a default user (one user used by
many ppl.. something like "guest")
I want to let only few users to use this access application without
having to logout from the default user logged in the computer.

to leto only users with their username and password defined in active
directory to use this application

thanks

"Francesco" <(E-Mail Removed)> wrote in message
news:123c73e6-210e-4486-a244-(E-Mail Removed)...
> On 4 Gen, 13:53, "Douglas J. Steele"
> <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
>
>>
>> Do you mean you want to challenge them (make them rekey their password)?
>> Randy Birch has sample code
>> athttp://vbnet.mvps.org/code/network/acceptsecuritycontext.htm
>>
>> Otherwise, please explain what you mean by "authenticate the user ...
>> using
>> active directory validation". They're already on your network, so they've
>> presumably already been authenticated.
>
> users are validated on this pc with a default user (one user used by
> many ppl.. something like "guest")
> I want to let only few users to use this access application without
> having to logout from the default user logged in the computer.
>
> to leto only users with their username and password defined in active
> directory to use this application

Did you look at the reference I cited? Seems to me it should do what you're
looking for.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

On 6 Gen, 19:25, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

> Did you look at the reference I cited? Seems to me it should do what you're
> looking for.

good thanks!! that is great!