VBA to authenticate using smart card

Apryl Stoldt 0 Reputation points
2023-03-15T20:04:14.0833333+00:00

I am working with a Microsoft Access 2016 database that connects to a server to retrieve some data. Currently the WinHTTPReq.SetClientCertificate is hard in to select the certificate in which it wants to use for authentication. Upon doing research I found that if the card is loaded with more than one certificate, it will pick up the first certificate with the first line matching what was set in WinHTTPReq.SetClientCertificate. On my smart card the option I need is the second certificate.

My question is: Instead of hard coding the user information into the VBA code, can we use VBA so that there is a pop up box to allow you to select which certificate you want to use? When I access the website via the web this is how I authenticate.

Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
686 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
380 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.