--- In [email protected], "Toby Bierly" <[EMAIL PROTECTED]> wrote: > 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've used the user level security on a pretty regular basis and unfortunetly it only goes to the table/query/form/report/module level. What you could do is limit the access to the data by ensuring that people can't get to the database window and limit the access to prevent anyone but those authorized to view all the data, change/write any new queries or reports. That way you could design some general reports to show them the information that they need to see. > 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. The workgroup file will work with any database that you open the database through the workgroup. In general I leave myself and my users attached to the default workgroup file but create a shortcut that allows them to open the relevant database. If your question pertains more to the using different access levels for different users in different databases the same workgroup will allow you to set different accesses for users in seperate databases. One final suggestion I would hesitate to set up permissions based on users, instead define several groups for your users and define your permissions at a group level. Hope that helped. Mike ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hnr1lkp/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124832310/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
