In my last post (here), I mentioned the possibility of authenticating to Active Directory as a means of securing an Access
Well, I've been looking into this more and I can't figure out how to do it. I've found plenty of snippits that look at the
currently logged on user, but none that actually go through the AD authentication process (with a password and
What I'm thinking of doing (or trying, really) is fairly simple:
A user opens the Access Database and is presented with a log on Form.They enter a Username and Password which Access compares
against Active Directory.
If Access finds that user and the password authenticates, Access checks to see if they're in the "Access Database Users"
Group (again, in Active Directory).
If they are a member of that group, then Access brings up the main Database Switchboard.If not, then Access gives them an
error message and lets them try to log in again.
If the user doesn't authenticate, then Access gives them an error
message and lets them try to log in again.
And, of course, after multiple failed tries (3-5), the database closes
and/or sends an alert to the admin (me).
I want Access to query the user/pass so that a different user than the one logged on to the local computer can connect to the
Database with their own (separate) username and permissions. Also, so random people can't just open up Access and mess with
the DB if the user leaves the computer unattended without locking it.
Anyone have any idea on how to actually perform that log on process? I can create the log on Form, query the username and
group membership, but I haven't found a way to verify the password.