Solved

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

Posted on 2013-11-03
4
293 Views
Last Modified: 2013-11-04
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
Comment
Question by:bcreen
  • 3
4 Comments
 
LVL 57
ID: 39621356
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
 
LVL 57
ID: 39621561
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
 

Author Comment

by:bcreen
ID: 39621587
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
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39621624
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question