I am running Access 03, and have two tables, I would like three columns in one table to be edited by some employees, and full admin of editing fields by others. Can this be accomplished through the security settings? Ideally two separate passwords would be used, one for admin, and one for regular employees, similar to a Windows login, then based on the password given, have three columns be capable of updates, or all columns be capable of updates. Thanks for any help.
Paul