• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

Can ms Access be used to process e-verify requests?

Is there a way to use Ms Access to verify one potential new-hire employee at a time thru the E-Verify government website?
0
bcreen
Asked:
bcreen
  • 3
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Since no one has bitten at this yet, I'll start off by saying I'm not really sure.  However Access has a wide range of capabilities and at the end of the day, there's not much you can't do with it.

For example, you can use web based services that calculate sales tax with a POST request to a web server, or process credit card transactions.   You can also download FTP files, read/write to many databases, etc.

I'm not familer with e-verify, but I think we could figure it out.   If no one else jumps in by the end of the day, I'll dig into it.

But do you code or no?   I'm guessing any type of solution would require some coding work.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
OK, I did a little digging and here's what I found.

The design requirements for the web service method are not made public.   You only can receive a copy of the Web Service Interface Control Document after you've signed up for Web services.

Web services sign-up allows you to use the web site manually until your software is developed.

So the answer to your question is most likely yes, it is possible.   As I pointed out in my first comment, there already is Access software which can work with web sites for real time requests (sales tax, credit card processing, etc).

 However, without the document in front of me, I can't say with 100% certainty.  There are three or four different ways that software can interact with a web site.

 Keep in mind though that people offering services want to make it as painless as possible to use a service, so they often will offer different methods of communicating with a site, or will offer the most common standards, which is SOAP or simple HTTP POST/GET, both of which Access (VBA) can do.

Jim.
0
 
bcreenAuthor Commented:
Thanks Jim.  yes I am a 20+ year "coder" and love and use VBA extensively in hundreds of Access (and Excel) applications.

My client is already signed up with E-Verify, so they likely have access to the documentation; I will see if I can examine it.  Also, I can now google (or search on Experts Exchange) for "Ms Access +SOAP" and "Ms Access +HTTP POST/GET".

I've done so MANY things in the past that I never thought Access could do -- most with great success -- so I agree that there is USUALLY 'a way' to make Access work.  Already pursuing credit card processing.

A much appreciated response.  If no one can actually "show me the code", I'm inclined to accept yours as the solution !
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Well just so you have an idea of what this might look like, below is some code used to make an HTTP POST request.   The code below is capturing a credit card.

 I would not be shocked if the doc's included examples for VB or VB.Net.

 The only issue you might have is if the examples given use a lib that is only for VB.Net.  Then it might take some digging to find a compareable lib for VBA.

  Like I said though, generally web sites like these want to support the widest amount of software possible, so they will either offer multiple methods or stick to the simplest.

Jim.


                  ' Set the correct URL
                  'strPostURL = "https://test.authorize.net/gateway/transact.dll"
110               strPostURL = "https://secure.authorize.net/gateway/transact.dll"
                  'strPostURL = "https://developer.authorize.net/tools/paramdump/index.php"

120               strPostSting = ""
125               strPostSting = strPostSting & "x_login=" & URLEncode(strAPILogin) & "&"
126               strPostSting = strPostSting & "x_tran_key=" & URLEncode(strTransactionKey) & "&"
                  'For debugging.
                  'strPostSting = strPostSting & "x_test_request=" & URLEncode("TRUE") & "&"
130               strPostSting = strPostSting & "x_version=" & URLEncode("3.1") & "&"
140               strPostSting = strPostSting & "x_delim_data=" & URLEncode("TRUE") & "&"
150               strPostSting = strPostSting & "x_delim_char=" & URLEncode("|") & "&"
160               strPostSting = strPostSting & "x_relay_response=" & URLEncode("FALSE") & "&"
170               strPostSting = strPostSting & "x_email_customer=" & URLEncode("FALSE") & "&"

180               strPostSting = strPostSting & "x_type=" & URLEncode("PRIOR_AUTH_CAPTURE") & "&"
190               strPostSting = strPostSting & "x_trans_id=" & URLEncode(rs!CCTransactionID) & "&"

                  ' Additional fields can be added here as outlined in the AIM integration
                  ' guide at: http://developer.authorize.net
200               strPostSting = left(strPostSting, Len(strPostSting) - 1)

                  ' We use xmlHTTP to submit the input values and record the response
                  Dim objRequest As New MSXML2.XMLHTTP
210               objRequest.Open "POST", strPostURL, False
220               objRequest.Send strPostSting
230               strPostResponse = objRequest.responseText
                  'Debug.Print strPostResponse
240               Set objRequest = Nothing

                  ' the response string is broken into an array using the specified delimiting character
250               arrResponse = Split(strPostResponse, "|", -1)

260               If arrResponse(0) = 1 Then
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now