Keeping users from seeing certain fields

[ps40life]

I have a field called Equivalent in a table named Residents. There are certain users who should not be able to see this one Equivalent field. They need to be able to access the other fields though, like name, room, etc.

I have security set up for the database, and from what I understand they have to have Read access for the entire table if this data is included on other forms and reports. First, is that correct? Because when I test it and turn off the Read permission, all the other data in the Resident table is inaccessible.

So, I thought about putting an input mask on this field. That seems like a good solution, but how do I let the other people who need to see this one field convert it back to the actual characters? I imagine I can then include it on certain forms and only allow the users I want to view it. Or is there a better solution?
Thanks for any suggestions!

 

[JeremyNYC]

Two ways to deal with this.

1) Make a one-to-one table that has the PK of your original table as a foreign key and the column you want hidden. Set the permissions differently for this table.

2) Give the users no permission on the table. Make all user access to the data through queries. Make the queries RWOP (Run With Owner's Permissions).

The second one is probably the better option.

Hope this helps.

Jeremy =============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing, Developing, and Deploying Access databases since 1995.