I have a database that I need the SSN number for employees as the key. I
want to make it so I can input the SSN number when I add an employee but make
it so others that need to veiw the database can not see the number.
How can I do this?
Thanks
What I'd suggest is that you create a surrogate key - it could be an
Autonumber - in the employee table, and make IT the primary key; use it for
linking to the other tables.
Leave the SSN field in the Employee table, with a unique Index, but not make
it the primary key; and of course don't include it in any other tables.
You'll need to prohibit access to table design view, and provide forms which
conceal the SSN field from everyone except you (or those authorized to enter
data), using Access security. See the Microsoft Access 2000 Security FAQ:
http://support.microsoft.com/kb/207793/en-us
Another MVP very aptly described this document as "thirty pages, no filler" -
it's dense, complicated, and can easily be done wrong, so study it CAREFULLY
and follow its instructions to the letter!