[AccessDevelopers] Access Security

[Toby Bierly]

Never played with Access' security before.  I have Access 97 at work.  I have been reading the Help file on User-level Security but am still unclear on a couple things.   In a database I was programming for Human Resources, I have a ODBC table linked from an SQL database.  It contains sensitive payroll information as well as the data that HR needs.   Is it even possible to set it so that the HR guys can't even read specific columns in the linked table?   I'm guessing if I set up User-level Security, I could get it to where at least they couldn't change the data in the table, but I'm not sure if I can deny read access to certain columns.   Also, if I try setting up a Workgroup Information File, how do I limit the settings so they only apply to a single database.  I may be confused, but it seems from what I read in Help that the Workgroup file affects all Access databases.   TIA, Toby Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.