Using Active Directory in XP OS Environment for Access Security

[OldGrinch]

I have no idea if this is possible, but I would like to invoke the Windows
Logon so that when a user launches a specific Access database they will have
to supply their domain credentials and password. If this authentication is
successful, I would then like to return success to Access so that it knows to
open up using the security appropriate to that user. Is this possible? If
so, can someone lead me in the right direction?

 

[Douglas J. Steele]

See whether what Randy Birch has at
http://vbnet.mvps.org/code/network/acceptsecuritycontext.htm is what you're
after.

Obligatory warning: Randy's site is aimed at VB programmers. There are
significant differences between controls available for forms in VB and in
Access, so that his samples usually cannot simply be copied into Access. For
instance, in VB, you set a value in a text box by referring to its Text
property, whereas in Access, you cannot refer to a control's Text property
unless the control has focus (you can either leave off the reference to a
property, or use the Value property)

 

[Tom van Stiphout]

On Tue, 8 Sep 2009 08:32:03 -0700, OldGrinch

I would take a bit different approach: the user is already validated
by Windows. There are API calls to find out who she is, e.g. the
much-cited http://www.mvps.org/access/api/api0008.htm

You still have to solve the issue of how to assign the user to some
groups. This can be done using AD, or perhaps a table in your
database.

-Tom.
Microsoft Access MVP