Masking Social Security numbers "kjtrip" <triplettkj[ at ]11meu.usmc.mil> 03.08.2006 02:44:47 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?

Re: Masking Social Security numbers "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 03.08.2006 03:08:56 "xxxxxxx" & Right$(SSNo,4) or "xxxxxxx" & Right$(Str$(SSNo),4) "kjtrip" <triplettkj[ at ]11meu.usmc.mil> wrote in message news:1154573087.736052.223210[ at ]s13g2000cwa.googlegroups.com... [Quoted Text] > 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? >

Re: Masking Social Security numbers "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 04.08.2006 03:04:01 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" <phad_nospam[ at ]cleardotnet.nz> wrote in message > [Quoted Text] >"xxxxxxx" & Right$(SSNo,4) > > or > > "xxxxxxx" & Right$(Str$(SSNo),4) > > "kjtrip" <triplettkj[ at ]11meu.usmc.mil> wrote in message > news:1154573087.736052.223210[ at ]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? > > > >

Re: Masking Social Security numbers "Keith Wilby" <here[ at ]there.com> 04.08.2006 07:57:10 "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> wrote in message news:%23jsi%23J3tGHA.4544[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > 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.

Re: Masking Social Security numbers "Chris Mills" <phad_nospam[ at ]cleardotnet.nz> 04.08.2006 08:13:31 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 "Keith Wilby" <here[ at ]there.com> wrote in message... [Quoted Text] > IMO there's no question at all; no sensitive information like this should > *ever* be stored in Access. > > Keith. > >

Re: Masking Social Security numbers <workinghard[ at ]news.postalias> 17.08.2006 17:37:40 Perhaps you should tell somebody to use encryption when storing such information ... "kjtrip" <triplettkj[ at ]11meu.usmc.mil> wrote in message news:1154573087.736052.223210[ at ]s13g2000cwa.googlegroups.com... [Quoted Text] >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? >