Security Permissions

[Luther1978]

I have a personnel Database, in which I hold a pay frequency field for each employee ("weekly" or "monthly&quot.

I have set up a group permissions for a weekly set of users and a monthly set of users.

I want the users who are a member of the weekly group only to be able to see those who are weekly paid. Short of creating 2 tables one for weekly and one for monthly paid how do I go about this. My first thought was give permissions to a weekly query run of the main table but give no permissions to the table. However it seems the query won't run without permissions given to the table.

The only other solution I can forsee is to seperate the table into 2, those who are monthly and those who are weekly. All very well except how do I set a new record to find the correct table?

Many Thanks in advance

Martin King

 

[JeremyNYC]

Martin,

No need for a new table. Look into help for RWOP, Run With Owners Permissions, which will let users run queries using the permissions of the person who created the query. Also, look in the security FAQ for code to determine what group the person is in. You could make a field's visible property depend on the user's membership in a particular group. I've got a copy of the FAQ on my website.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[Luther1978]

Thanks Jeremy, already found the run with owners permissions, but the MS FAQ will certainly be some help