Link to home
Start Free TrialLog in
Avatar of bcreen
bcreenFlag for United States of America

asked on

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?
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

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.
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.
Avatar of bcreen

ASKER

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 !
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial