Security of form data stored in a file?

  • Thread starter Thread starter Mr B
  • Start date Start date
M

Mr B

Howdy,

We are setting up a form in which one of the fields is a Credit Card number. We want to submit the
data to a file so that it doesn't have to be re-entered into a spreadsheet after-the-fact. (Either
just a CSV file or a database would probably work) We are getting secure access to our site
(https://..) but how can I make sure that the file itself isn't easily accessible? Can I put it
somewhere where it would need a password to be opened or something like that?

Thanks.
 
Hi,
Putting it in the _private folder works.

Just a note. If the spreadsheet you use is Excel you will have a problem
when it opens the file.
Excel will chop all numbers to 15 digits. (cc's are usually 16 digits) You
need to read the data into Excel as text instead of just opening the file.
Or open it in notepad and paste into an Excel range predefined as text.
(format>cells>text)
 
You best bet is to create an application that does this and store the credit
card number in an encrypted format. If you store as plain text, you may end
up having the number stolen, which would not be a nice thing.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
What if I have the form dump to an Access Database using the DRW stuff... THe site supports ASP but
I don't have much experience with databases and FP. Can I put a password on the MDB file so no one
can open it but the form can still write to it? Woudl that be safer?
 
Back
Top