|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Masking Social Security numbersI 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? "xxxxxxx" & Right$(SSNo,4)
or "xxxxxxx" & Right$(Str$(SSNo),4) Show quoteHide quote "kjtrip" <triplet***@11meu.usmc.mil> wrote in message news:1154573087.736052.223210@s13g2000cwa.googlegroups.com... > 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 :-) Show quoteHide quote "Chris Mills" <phad_nospam@cleardotnet.nz> wrote in message > >"xxxxxxx" & Right$(SSNo,4) > > or > > "xxxxxxx" & Right$(Str$(SSNo),4) > > "kjtrip" <triplet***@11meu.usmc.mil> wrote in message > news:1154573087.736052.223210@s13g2000cwa.googlegroups.com... > > 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" <phad_nospam@cleardotnet.nz> wrote in message IMO there's no question at all; no sensitive information like this should news:%23jsi%23J3tGHA.4544@TK2MSFTNGP04.phx.gbl... > 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. *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 Show quoteHide quote "Keith Wilby" <h***@there.com> wrote in message... > IMO there's no question at all; no sensitive information like this should > *ever* be stored in Access. > > Keith. > > Perhaps you should tell somebody to use encryption when storing such
information ... Show quoteHide quote "kjtrip" <triplet***@11meu.usmc.mil> wrote in message news:1154573087.736052.223210@s13g2000cwa.googlegroups.com... >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? > 
Other interesting topics
application deployment for SP2
Problem with Multi-users in Access97 Linked Tables Security Problem shift override in split database Suggestion on deploying and securing an Access appl Disabling Password in Access... Security has gone wild. Database Password how I add an username + posword to a mdb file? Is it a good idea to create my own navigational buttons ?? |
|||||||||||||||||||||||
