ASSIGN DIFFERENT COLUMN LEVEL PERMISSIONS IN THE SAME TABLE

[F. SARKIS]

I am trying to have different permissions (read/write/modify...etc) assigned
to different columns in the same table for different users. Is there any way
to do this using Microsoft Access? Thanks for your help.

 

[Wayne Morgan]

Yes and no. The first thing that comes to mind would be to build queries
that access the desired columns and place permissions on the queries using
User Level Security. The best option though, would probably be to control
access to the data using a form. You could determine who the user is and
program the form to lock/unlock or hide/unhide controls as desired.

 

[msnews.microsoft,com]

I am trying to have different permissions (read/write/modify...etc) assigned
to different columns in the same table for different users. Is there any way
to do this using Microsoft Access? Thanks for your help.