RE: About my Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I don't have an anser to your specific question.
However, I feel very uneasy whenever I hear of anyone storing SSNs in a
database, especiually a database as unsecure as Microsoft Access. As you may
be aware, identity theft is one of fastest growing areas of crime. Unless you
absolutely must store social security numbers, I would avoid it. Try to come
up with some type of employee number (this is now mandated in many cases by
the Government, although probably not the military as they seem to be
excepted from almost all laws). If you must store social security numbers,
try to keep the rest of the personal information (especially the persons name
and address) elsewhere and not easily associated with the SSN. It would not
hurt to encrypt the SSNs either.

"Robert" wrote:

> Hello Again Everyone
>
> As mentioned earlier, I would probabally be posting a great deal. Here
> is the overview of my database and a subsequent problem I am having.
>
> Initially, there was one HUGE table, now I have several tables, these
> are named as follows:
>
> These are tables that are referenced by autolookup fields
>
> LstBldTyp
> LstClnc
> LstGndr
> LstKeyBilletO
> LstRankList
> LstSwimClass
> LstWorkSection
> LstWpnsQual
>
> These are tables that contain data
>
> TblG3Account
> TblG3Basic
> TblG3Clnc
> TblG3Med
> TblG3NoK
> TblG3NonResPME
> TblG3OIF0406TrngALL
> TblG3OIF0406TrngSel
> TblG3Promo
> TblG3Recall
> TblG3ResPME
> TblG3Skills
> TblG3Training
> TblG3Uniform
> TblG3Vehicle
> TblG3Weapons
>
> I use the TblG3Basic as (what I consider) my master table with the
> basic information. I am using a MbrSSN field (Social Security Number)
> as the master key and as my reference for all relationships on a one to
> one basis.
>
> When I open my TblG3Basic, I do not see any of the sub datasheets,
> Trying to figure out why that is. Also as I said, I use my TblG3Basic
> as the starting point, I am trying to figure out how to get it so that
> when I enter a social security number in, it cascades through all of my
> other tables (creates a new record I guess). I have referential
> integrity and cascade update and delete, but for some reason I still
> have to enter the SSN's manually...
>
> Any help would be appreciated, if you need more information, please let
> me know!!
>
> Robert A. Wukich, Sr
> Sgt/USMC
>
>
.

Relevant Pages

  • The "Zero Accountability" Bush Administration Exposes Your Private Data
    ... Govt Public Database Exposed SS Numbers of 63,000 People ... her Social Security number was displayed in plain view on a U.S. ... the public needs to provide the Federal Award ...
    (alt.politics)
  • RE: Honeytokens and detection
    ... The Social Security Administration has provided some information ... Subject: Honeytokens and detection ... I've been playing with the concept of Honeytokens, ... database, or looking where they shouldn't be. ...
    (Focus-IDS)
  • Re: can i build a client data base
    ... database to track your own clients? ... Make a list of all the data you'll need to accomplish and what kind of data ... numbers, ID numbers, SSNs, etc but are not used for math should be defined as ... That's a very broad outline of the creation of a database by me, ...
    (microsoft.public.access.gettingstarted)
  • Re: Medicare ID & social security number
    ... It is surprising that Medicare uses the Social Security Number as its ... account ID, what with all the emphasis lately on thwarting identity theft ... The Banking Secrecy Act of 1970 extended the use of SSNs as IDs to finance. ...
    (soc.retirement)
  • Re: OT-Whats With Our Law Enforcement Officers?
    ... amidst an otherwise good post on the illegal invasion issue: ... Social Security Administration) compares that information and sends ... security cardholders provide a thumb print. ... stored in the same SSA database so that if a person matched the SSN, ...
    (rec.outdoors.rv-travel)