473,241 Members | 1,770 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

Credit card payments

What is the simplest way to implement credit card payments in a Microsoft Access VBA POS program?
Apr 25 '22 #1
4 13384
453 Expert Mod 256MB
Don't do it!

No matter, how hard you try to implement security measures in Access, it really isn't secure enough to use with credit card information.
If (when?) there are data breaches, you could be personally liable
Apr 25 '22 #2
5,501 Expert Mod 4TB
I absolutely agree with isladogs' Assessment that Access isn't secure enough to store credit card information persay...

So many venders out there that offer CC/DC processing for a very nominal fee, and many will also provide you with a free terminal, that you really should consider using them for the transactions and create your POS in Access to do your inventory and cash-register functions.

With that said, keep in mind that real-time credit card transactions require some very specific encoding from the terminal to the bank that simply isn't available directly within AccessVBA - you would need to find an API/DLL call, they're out there in the wild; however, I would be VERY uneasy using any of these files unless it came directly from the Banking institution.

Storing the CC number - I CANNOT STESS ENOUGH that you would absolutely have to encrypt every single CC/DC individually using something along the lines of Rabbit's AES example ideally using some sort of unique password for every record IN ADDITION to the normal password encryption offered by MSAccess - I would advise changing the default setting to use "strong encryption" and absolutely nothing older than MSOFFICE/MSACCESS-2013
>> KEEP IN MIND HERE >> IF you had a data breach, you could be potentially liable for several thousands of dollars in damages and fines
-IMHO: just don't do it - work with your financial institution or contact one of the Paypal, Square, etc... venders to help you setup a business account to handle the DC/CC - I just recently did this for a close friend for his business - Access for the inventory, invoicing, etc... and his Bank set him up with a POS chip-reader/printer for a really small monthly fee (and if he has over so-many transactions a month the fee is even waived)
Apr 26 '22 #3
32,554 Expert Mod 16PB
I hope that, by now, you no longer need further endorsement of the idea that handling POS directly from within an Access project is a concept to avoid like the plague (almost literally). Nevertheless, in case you do, I say "Don't even think about it". Like both of the other two experienced experts, and I'll be very happy for isladogs to post links here to his own work on this very subject, I am reasonably knowledgeable in these matters. Even I defer to isladogs as an expert and trainer in this field.
Apr 26 '22 #4
453 Expert Mod 256MB
Following on from earlier comments, as @NeoPa indicated, I've done a lot of work on database security and know how to make an Access database as secure as its possible to do. For example, see my 3-part article: Improving Security in Access Databases. In particular, look at part 2. Notice I used the words "Improving Security...". That doesn't mean it is unbreakable.

If I was asked to create an Access database to handle credit card transactions, I would refuse the assignment. It just isn't safe.

@zmbd indicated the correct approach. Purchase a card reader designed specifically for the purpose which would handle all the security on your behalf. If that fails due to a data breach, the card reader supplier would be liable...not you.
Apr 27 '22 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

by: sam1967 | last post by:
I know how to build forms with ASP and process user input. Now i want to take credit card payments via a form. i will then download the details and process them via our credit card machine. do...
by: Simon Wigzell | last post by:
My client wants to have credit card information fields on his forms for his website visitors to be able to buy his wervices by credit card. The credit card info - Brand, number and expiry date will...
by: Street | last post by:
Web Site Robot creates and hosts your web site or online store with secure credit card payments in minutes. No web hosting company, no HTML, no secure certificates are required. Please download...
by: gj | last post by:
I have an application in Access 97 I will be rewriting in the latest version of Access in 6 months. In the meantime, does anyone know of an ActiveX control I can add into an Access 97 form to...
by: gl | last post by:
I have just started a project that's going to do very heavy credit card processing through asp.net and i had some questions. I've never really done any cc processing through code and I wasn't sure...
by: nm | last post by:
Hi, I am a developer quite familiar with the C# language and .NET framework. I develop mainly data driven websites. All of our past clients have shopping cart systems developed by me in ASP.NET...
by: Patrick | last post by:
I'd like for some of the users of my web application to pay some money through their credit cards. How can i enable this?? Any guide lines, articles, how tos related to this!?
by: imrosie | last post by:
Hello, I'm trying to figure out how to store only the last 4 digits of a credit card number in a 'Payments' table. paymentid is the primary key, not credit card number. I tried using the...
by: Jezternz | last post by:
Hey, I would like to use credit card payments or/and paypal payments, to activate something on my website. ie. A user is sent to a page and pays (via cc or pp) and once the money is accepted the...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.