Credit Card Processing

[Tracy Smith]

Has anyone integrated a web-based credit card processor into an Access app?
What vendor did you use? Any sample code?

 

[ryguy7272]

If you want a dynamic solution, ASP.NET and SQL Server; only way to go.
Else, download the file and import it into Access. Perhaps Access 2010 will
permit you to dynamically query web sites; I don't know for sure because I
haven't used it yet.

 

[vanderghast]

It would be ugly if only ASP.net or SQL server were able to consume a web
service... All those Linux guys would do what for a living?

No, sure, you can ***consume*** a web service from Access too, quite easily,
as presented at
http://www.databasejournal.com/feat...p/3567511/Consume-Web-Service-from-Access.htm



Vanderghast, Access MVP

 

[Tracy Smith]

I assumed it would be through a consumed web-service. I was wondering if
there was a specific one that anyone has used??

 

[ryguy7272]

If you don't want to learn ASP.NET (and I'll admit it's QUITE A LOT), then
perhaps your only other option is to get Office 2010. You can get a free
copy here
http://www.microsoft.com/office/2010/en/download-office-professional-plus/default.aspx

http://www.microsoft.com/office/2010/en/access/default.aspx

I don't know for sure if this version of Access will do what you want, but I
know it is much more web-friendly than 2007, and anything prior to that, for
sure. I'm going to download this new version of Office when i get home
tonight. Then I'll have a better feel for the app.

 

[vanderghast]

For a credit cards? not that I am aware of. For web services in general?
the already proposed link gave at least one (unless it is now closed, which
is part of the problem, with web services).

Vanderghast, Access MVP