asked on

How do I Validate a password entered in an Access 2003 Form with AD

I have an Access 2003 DB Front-end with MS SQL 2005 Back-end. Some of our shop users login to their PCs using a common "Shop" account. They also have a "Personal" account for accessing MS Exchange e-mail using OWA so do have a personal AD account.

When these users open Access I wish them to "Login" using their normal AD Username & Password.

Any hints/code how I can achieve this?

Paka

Are you shop owners on a common domain or are they accessing the Access/SQL through web app?

CABHugh

ASKER

They are connectiong to a RDP session on Terminal Servers in our Data Centre. They then open the Access 2003 Front-end in the session. Each Receptionist in the Shop, up to 4, uses a common login for access but I wish Access to record the actual individual using that session. As I've said, they do all have personal accounts as well so it would be easier for me to make use to that username and password rather than creating new passwords just for the DB which would be hard to maintain going forward.

Paka

What kind of PCs do they have? Would you be able to copy the Access front end to them and have the users log in using their AD accounts? In this way, you would be able to integrated SQL authentication to enforce the security and auditing...

CABHugh

ASKER

Not possible. They are using TS over a ADSL VPN (Slow). Everything runs on servers in the same datacentre so we get good local speed there. I would like to open a login screen when Access opens and ask them to enter their personal AD Username & Password. Im sure ther must then be a way, in VBA, to authenticate the credentials with AD. If the authentication failed then the form would Quit the Access DB.

I just need that bit of VBA!!!

ASKER CERTIFIED SOLUTION

CABHugh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial