?
Solved

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

Posted on 2013-11-03
4
Medium Priority
?
296 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 58
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 58
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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

650 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