I know how to set sign-on’s for an Access 97 database and create some permissions. What I need to know: Is there a way to restrict a user from one column, but give them access to the rest of the record. I know how to restrict from updates, but that restricts the entire record not certain columns of the record. EXAMPLE: I have a database that has a column for patient name, x-ray receive date and x-ray return date. I need to restrict any changes to the patient name and x-ray received date, but get access to change the x-ray return date. Is there anyone who know how to accomplish this? Thanks! -KPike-
