Different access levels within a table

[binoj]

I have a table with 5 columns that needs to be accessed by multiple users. The 5th column is read only for common users and only the admins should have write access to that column.

How can I implement this. I am building an access 2003 app using ms access 2007.

Any help is greatly appreciated.

 

[gemma-the-husky]

users should not open tables directly

so use 2 forms - one for all users, and one for admin users only, with the extra column.

if you want to get really clever, (but it is this more complex to manage) this is one time when a 1-1 join may be useful, so that normal users do not get privileges for the joined "secure" table

 

[binoj]

Thanks. I had thought about 2 separate forms method. I wasn't aware of the join type method. Looks like 2 separate forms is easier to implement. I am going to go with that.