I have a customer using the latest version of Access with a SQL Server database backend. They want to integrate credit card processing into the Access front end application. Any suggestions?
My advice is to say no to their request. Access isn't secure enough to use for credit card data even if it is contained in a SQL Server BE. Whether or not you are in a country subject to GDPR, I would advise you to study the implications and liabilities if the data becomes compromised