Access Security and Active Directory

  • Thread starter Thread starter Kathryn Birstein
  • Start date Start date
K

Kathryn Birstein

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