Masking Social Security numbers

[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?

 

[Chris Mills]

"xxxxxxx" & Right$(SSNo,4)

or

"xxxxxxx" & Right$(Str$(SSNo),4)

 

[Chris Mills]

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

 

[Keith Wilby]

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.

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

Keith.

 

[Chris Mills]

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

 

[Guest]

Perhaps you should tell somebody to use encryption when storing such
information ...