[AccessD] Hiding SSN

Cindy,

Using user level security you can set the permissions for each object so
only those belonging to the proper groups can read/write/create/delete
certain objects.  The Access Security FAQ was up as of a minute before I
hit the Send button.
http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcon
tent%2Fsecfaq%2Easp (watch for line wrap)

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: CYNTHIA SPELL [mailto:CSPELL at jhuccp.org] 
Sent: Friday 2003 May 02 07:06
To: accessd at databaseadvisors.com
Subject: RE: [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