Using Windows Certificates with VBA
Experts,
I'm trying to read certificates in Windows with VBA, I was wondering how to go about this. Everytime I search the internet for this, it throughs me into "how to digitally sign an access database". Here are the specifics the certificates are published to windows, I would like to just use the ones that are published not read off of a smart card(DOD Common Access Card). Any help is apprecaited
I'm trying to read certificates in Windows with VBA, I was wondering how to go about this. Everytime I search the internet for this, it throughs me into "how to digitally sign an access database". Here are the specifics the certificates are published to windows, I would like to just use the ones that are published not read off of a smart card(DOD Common Access Card). Any help is apprecaited
Hello DanaGarcia,
PLace the database in a trusted area or add the folder to the trusted locations. Alternatively you can self certificate the database but with 2007 I find trusting a location and placing the files in that location works very well.
See http://office.microsoft.com/en-us/powerpoint/HA100310711033.aspx#4 for some general info.
Regards,
chris_bottomley
PLace the database in a trusted area or add the folder to the trusted locations. Alternatively you can self certificate the database but with 2007 I find trusting a location and placing the files in that location works very well.
See http://office.microsoft.com/en-us/powerpoint/HA100310711033.aspx#4 for some general info.
Regards,
chris_bottomley
ASKER
LSMConsulting,
We all have a CAC(Common Access Card) that is issued to us for computer access among other things, Everyone has a digital signature on their card, I need to access that signature in vba to add it into the database to show who it came from.
We all have a CAC(Common Access Card) that is issued to us for computer access among other things, Everyone has a digital signature on their card, I need to access that signature in vba to add it into the database to show who it came from.
I believe you've asked something similar before. VBA would really have no mechanism to interact with that card, but the vendor of that card may have published an API/SDK which would allow your VBA code to read and verify that signature.
Is this not something that an Windows environment variable would tell you? What is your overall purpose of this? Do you simply want to "stamp" a record when a user edits, or something along those lines?
Is this not something that an Windows environment variable would tell you? What is your overall purpose of this? Do you simply want to "stamp" a record when a user edits, or something along those lines?
ASKER
Exactly and thats what i'm asking is if you guys know what the environment variable is? P.S. I have never asked anything about a card or certificates.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yeah I know about the Environ("USERNAME") part, I did what you said as far as typing in set and there is no smartcard variable or any certificate variable. I guess USERNAME Environment Variable is as close as i'll get to actually signing.
ASKER
Thanks for your time, You did a good job but I'm still left with questions. Have a good day, and a happy New Year
What exactly are you trying to accomplish?