Masking Social Security numbers

  • Thread starter Thread starter kjtrip
  • Start date Start date
K

kjtrip

I need to be able to run a query in Access 2003 that takes the
information from a field "Social Security Number" and masks all but
the last four digits. Is this possible?
 
Oy!

I was expecting some criticism for saying merely how to mask stuff in Access!

Of course, MS-Access is sufficiently insecure that there's some question
whether SS Nos should be stored in it at all.
See:
http://www.access.qbuilt.com/html/security.html#DoNotStoreSSNs
(scroll down the article)

According to the article, 27million Americans have suffered identity theft.
I'm Ok coz I'm not American<g>

....just don't sue me for giving one idea of how to mask things in Access,
please?

Cheers
Chris :-)
 
Chris Mills said:
Oy!

I was expecting some criticism for saying merely how to mask stuff in
Access!

Of course, MS-Access is sufficiently insecure that there's some question
whether SS Nos should be stored in it at all.
Click to expand...

IMO there's no question at all; no sensitive information like this should
*ever* be stored in Access.

Keith.
 
Yeah. I accept what they say at QBuilt. Fortunately for me, I don't even know
how long a US SSNo is <g>

But do you realise:
If 27million Americans have suffered identity theft THEN:

93million Americans HAVEN'T! <lets be positive><vbg>

(Seriously, seems to be a bad idea)
Chris
 
Back
Top