[AccessD] Hiding SSN

Thanks to those who responded to me...

Charles, I couldn't get into the website on Access security.  I guess what I need to know is - will that type of security prevent users from seeing the tables (using the shift key, F11?)  

Jim, I inherited the database and yes it's (gasp!) the primary key, so encryption won't work.  I'm thinking about biting the bullet and changing the PK to an autonumber.  Any thoughts on that?

David, I'm not letting users into the tables, only forms.  And hidden tables don't really seem to be hidden. 

Thanks again.

Cindy


>>> jim.hale at fleetpride.com 05/01/03 05:26PM >>>
I believe I've seen some simple encryption functions (maybe in SmartAccess?)
that can be used to scramble the numbers. that is one way to do it unless
(gasp!) you are using the SS# as the primary key.
Jim Hale

-----Original Message-----
From: CYNTHIA SPELL [mailto:CSPELL at jhuccp.org] 
Sent: Thursday, May 01, 2003 3:03 PM
To: accessd at databaseadvisors.com 
Subject: [AccessD] Hiding SSN


Is there a way that you can COMPLETELY hide an SSN field from users - keep
them out of the database window, don't let them see the table, etc?   

Thanks for your help.
Cindy




_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com