credit card processing in access? can it be done?

[Robert Blackwell]

We have an access dbase that works REALLY well for us. However, we are
really in need of a new program that can handle taking orders etc, but also
processing credit cards on the fly. BofA suggested a really crapy company
for us and it's really dissapointing. There's gotta be a good
program/database we could use that is just as flexible as our own.
Anyway, I don't want to get into the details of what we need....maybe not in
this thread anyway

What I'm wondering is if we can somehow configure access to process credit
card orders. We are on a small lan here and we all have access to cable.

In need of an immediate solution (seriously, yesterday would have been nice)
;o)
Robbie

 

[HSalim]

Robbie,
Have you tried using ICVerify?
regards
HS

 

[Robert Blackwell]

No, I've never heard of it until you just said.

So, this plugs into access and processes credit cards with my merchant
account?

 

[HSalim]

I've never used it myself but I know that it is a pretty decent program.
you could use PCAuthorize - which I guess is a flavor of ICVerify that comes
with a developer's Kit
information on their SDK is available here.
http://www.icverify.com/files/authdevkit.pdf


(I have some experience with Credit card authorixations, but it is in the
Great Plains world.)
ICVerify is owned by First Data which also owns Cybersource and is the big
daddy in payment processing. (electronic and paper)

Smaller accounting packages like Peachtree integrate with ICVerify for their
Credit Card Transactions.

Cybersource also puts out an SDK for payment authorizations using .NET and
Java but that may be over kill for you.

Good luck in your efforts
HS

 

[Robert Blackwell]

It looks like a standalone product. It would be nice to have an integrated
app so I don't have to repeatedly type customer information over and over. I
have hundreds of customers with the same orgization name (just different
cities etc) However, going by what I see onscreen, there is no where you can
enter a customer number so if I start typing in an orginization name say,
first baptist church it's gonna list all whatever number of em and I'm gonna
have to find out whichone. That is so difficult, our ups computer does that
too if you didn't enter a customer number.

 

[Robert Blackwell]

I'm bookmarking them and the cybersource guys. I'll probably have to call.

 

[Arvin Meyer]

Robert,

Unless your volume is sufficiently high to warrant the risk and liabilty of
processing credit card orders, I suggest you forward the customer to BofA or
another vendor who will do it for you for a small fee, of course. There are
routines which will validate the card in Access, but I can't vouch for their
reliability because I have only done this on the web and used SQL-Server for
the local database. I forward the customer and get back the validated data.
I never see the credit card in the web app, just the validated result.

Access in not secure enough to use for credit card information. A good
hacker will get the data without too much effort. A credit card processing
program will provide you with a validated code which you can then simply
enter in the Access field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access