Access database Credit card Number format

[john]

I'm designing an Access database. I need to store Credit card number, CVV and Expiry date. When I'm designing table I'm stuck at data type for CC Number and format for CC number, Expiry date. What's the best solution for these.
Thanks!

[Micron]

Can't tell where you're from, so I'll just do an FYI here. There is a standard you need to adhere to if you do this
https://www.pcisecuritystandards.org...ta_storage.pdf

Also note that Access is the least secure database program or interface that you could use for this, assuming you have a justifiable need to do so. To answer your question, date field for dates, single, double or text for card number (depending on spaces or not) and long for ccv number. My advice would be to forget doing this.

[john]

i know that. that's my personal database.

[isladogs]

Even in your own personal database on your home PC, think carefully about making it as secure as possible in case of theft etc
These articles on my website will give some pointers, some of which you may not have considered.
http://www.mendipdatasystems.co.uk/i...ity/4594461803 ; http://www.mendipdatasystems.co.uk/c...ity/4594444323

If I was going to do this at home, I would still put the data in a SQL server BE and use an encrypted ACCDE front end.

[john]

Awesome @Micron. Thanks for your suggestion.