I found this one while reading Mike Wolfe's Week in Review this week...
Here's a video from AccessUserGroups.org featuring Access MVP Adrien Bell demonstrating how to integrate Active Directory security features directly into your Access database: Watch the video here.
Adrien goes deep into how to check AD group membership from within Access using Windows APIs, and how to use that to control access to forms, reports, or features. If you're developing Access apps for a company that already uses Active Directory, this might be worth exploring. It can let you tap into the existing security infrastructure instead of reinventing the wheel.
That said, my take is this:
Most of the clients I've worked with are small businesses - 10 users or fewer - and the vast majority of them are not using Active Directory. It's overkill for a simple office network. So I've always built my own security system inside Access, like I teach in my Security Seminar. It's simple, flexible, and works great in non-domain environments.
But if you're working in a larger organization that already has AD in place, definitely check this out. It can save you from having to manage usernames, passwords, and roles manually.
Full disclosure: I skimmed the video, but I haven't tried this myself. Still, it's from Adrien Bell, so you know it's quality stuff.
I agree with you, Richard. Even with some of my customers who have 30-40-50 users, Active Directory is still an overkill.
Thomas Gonder
@Reply 15 months ago
I'm sure it's gotten better over the years, but AD was a nightmare when I dived into it years ago. So many bugs and impossible to figure out why things weren't working. I'm sure they cleaned up all the bugs, the same way they have in Access.
Yeah, the few times I've worked with Active Directory, it was a pain. But like I said, I'll be honest, I mostly worked with small companies that didn't really need that sophisticated level of security... or the headaches that came with it. The horror stories I've read...
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Captain's Log.