Dear All:

I was just wondering if Access Security interfaces at all
with the Active Directory of Windows 2000 Server. In
other words, is it possible to use the domain username
and password of a user for Access Security?

I think not since from all of my reading in this
newsgroup and the Knowledge Base article there is no
mention of how one would link in the domain username into
the .mdw file. . .

Thanks.

Kathryn

That is correct. You cannot integrate windows security with Access
security.

--
Joan Wild
Microsoft Access MVP

"Kathryn Birstein" <(E-Mail Removed)> wrote in message
news:12f901c372ca$43c26740$(E-Mail Removed)...
> Dear All:
>
> I was just wondering if Access Security interfaces at all
> with the Active Directory of Windows 2000 Server. In
> other words, is it possible to use the domain username
> and password of a user for Access Security?
>
> I think not since from all of my reading in this
> newsgroup and the Knowledge Base article there is no
> mention of how one would link in the domain username into
> the .mdw file. . .
>
> Thanks.
>
> Kathryn

I use code to lookup the user's 'Windows' logon and match it with a
table of users in my database. If they don't appear in the table then
a message pops up telling them they are not authoruised to use the
databse. All this happens in the Onload event of the splash screen, so
if they're not allowed in, then I do an Application.Quit before they
ever get near any of the rest of the databse forms.

If you need the code to extract the window's username try looking on
the mvps.org site, I think that's where I found it. I had to add all
the functionality within my application though. (ie. the table lookups
and msgboxes etc), but it's not all that difficult.

Cheers
David
Brisbane
Australia

On Thu, 4 Sep 2003 11:20:33 -0400, "Joan Wild"
<(E-Mail Removed)> wrote:

>That is correct. You cannot integrate windows security with Access
>security.

That's fine, but you don't appear to be using Access security, which is what
the question was about.

With Access security implemented, if their Access login failed, they'd never
even get to your startup code.

--
Joan Wild
Microsoft Access MVP

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I use code to lookup the user's 'Windows' logon and match it with a
> table of users in my database. If they don't appear in the table then
> a message pops up telling them they are not authoruised to use the
> databse. All this happens in the Onload event of the splash screen, so
> if they're not allowed in, then I do an Application.Quit before they
> ever get near any of the rest of the databse forms.
>
> If you need the code to extract the window's username try looking on
> the mvps.org site, I think that's where I found it. I had to add all
> the functionality within my application though. (ie. the table lookups
> and msgboxes etc), but it's not all that difficult.
>
> Cheers
> David
> Brisbane
> Australia
>
> On Thu, 4 Sep 2003 11:20:33 -0400, "Joan Wild"
> <(E-Mail Removed)> wrote:
>
> >That is correct. You cannot integrate windows security with Access
> >security.
>

When you secured the one database, you made a new workgroup. Access made
this the default one to use for all sessions.

Just use Start, Run, wrkgadm.exe and join your computer back to system.mdw
as the default. For your secure database, use a desktop shortcut with a
target of
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

It will use your secure workgroup for that one session, but will use the
default system.mdw for all others.

--
Joan Wild
Microsoft Access MVP

"MrElam" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Since it's not possible to use the Windows username and password, is
> there a way to set up a secured database that has a logon box, but leave
> your other databases alone so you don't have to logon? Once I set up
> security on one, I get a logon box every time I start Access. I'm using
> AC2000 on Windows 98.
>
>
> --
> Posted via http://dbforums.com