Link to home
Create AccountLog in
Avatar of BD
BDFlag for United States of America

asked on

Capture digital ID info (CAC) for use in MS Access form?

I would like to be able to have an MS Access form be able to capture the digital ID information (user credentials, certificate, etc.) of my users and populate a field in my form.  I am hoping there is something fairly simple that Access can do to call that information from the operating system and make it available for processing in a form.
Avatar of Ryan
Ryan
Flag of United States of America image

You can get Windows login ID.

MyText = Environ("username")
Can you clearly define what you are calling "user credentials" and "certificates"...

These things can mean different things depending on the context.
Avatar of BD

ASKER

All my users log into their computers using a CAC card.  I would like to be able to capture their user name and email address.  I believe that is associated with their CAC - it is info on the card.  I am not certain if this data should be refered to as "credentials" or a "certificate".  I unfortunately am not up to speed on the lingo and as always - I am trying to ask a question without knowing how to ask it...
SOLUTION
Avatar of Ryan
Ryan
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of BD

ASKER

Not sure if a database is referenced or not.  For example (what I am trying to emulate), Adobe Acrobat allows a user to "Digitally Sign" a PDF document.  When it does this, besides digital certificate locking stuff, it places text into the PDF document listing the signer's email address, the date, and the time.  I have seen on other occasions where some serial number or ID number is also placed in the PDF, but I would be happy if I could capture the email address at a minimum.  I can easily place the date and time.
I'll leave this to another expert, as I can only guess at this point. I think Adobe has stored that email address when you installed it.
Avatar of BD

ASKER

No, I do not think Adobe has stored anything as different users can login with their CACs and use the system.
iamsickofthisidshtuff,

I apologize for misunderstanding, ...

I did see the "CAC" specified in your post, ...but I thought that "user credentials" and "certificates"... were separate from the CAC
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of BD

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for iamsickofthisidshtuff's comment #a38617568

for the following reason:

No real obvious solution was found and that was not for a lack of input and insight provided.  It seems like this solution would take a great deal of effort and time to develop with no real guarantee of success.
What you've chosen as the answer is not really a "solution" - it seems to be more of an indication that you're not willing to delve into the matter any further. That's fine, but you should not accept that as the solution.

If you do feel it's a solution, then it would be in the realm of "you can't do that", which is a valid solution here on EE (see the Help page here: https://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=23). If you feel that is the correct solution, then you should award points to the Experts who told you this:

http:#a38606262
http:#a38608542

I also have no objection to a Delete, if the Moderators feel there is not enough information here to warrant a PAQ.