<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [AccessD] Hiding SSN</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=032163721-01052003><FONT face=Arial color=#0000ff
size=2>Cynthia, the best way is to not let them in the tables in the first
place. ANything that they need should be entered/viewed through a
form.</FONT></SPAN></DIV>
<DIV><SPAN class=032163721-01052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=032163721-01052003><FONT face=Arial color=#0000ff size=2>What
is it that they are doing, or that you don't want them to see. A query ran
against the table could show only the fields that you want to show (make it a
snap shot query if no changes are to be made to the data)</FONT></SPAN></DIV>
<DIV><SPAN class=032163721-01052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=032163721-01052003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=032163721-01052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=032163721-01052003><FONT face=Arial color=#0000ff size=2>David
McAfee</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left> </DIV>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
CYNTHIA SPELL [<A
href="mailto:CSPELL@jhuccp.org">mailto:CSPELL@jhuccp.org</A>]</FONT> <BR><FONT
size=2>Sent: Thursday, May 01, 2003 3:03 PM</FONT> <BR><FONT size=2>To:
accessd@databaseadvisors.com</FONT> <BR><FONT size=2>Subject: [AccessD] Hiding
SSN</FONT> </P><BR>
<P><FONT size=2>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? </FONT></P>
<P><FONT size=2>Thanks for your help.</FONT> <BR><FONT size=2>Cindy</FONT>
</P><BR><BR><BR>
<P><FONT size=2>_______________________________________________</FONT>
<BR><FONT size=2>AccessD mailing list</FONT> <BR><FONT
size=2>AccessD@databaseadvisors.com</FONT> <BR><FONT size=2><A
href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT size=2>Website: <A href="http://www.databaseadvisors.com"
target=_blank>http://www.databaseadvisors.com</A></FONT>
</P></BLOCKQUOTE></BODY></HTML>