New to SQL Server....

[MikeHost]

I have two tables that are set up in SQL Server. Both tables are linked in a 1-to-1 one relationship. One is a Customer Table and the second has supplimental information on the customer. Both tables are joined into one recordset.

I do not want the users to be able to update the information in the first table, but I do want the user to be able to update the information in the second.

My problem is that I don't know how to assign rights on individual fields. I have been able to assign the rights on the user view that will prevent changing the entire recordset, but I only want to be able to prevent a few fields.

[smh]

Do you have to assign the rights in the table? You could very easily just change the property of the textbox or whatnot the data will be displayed in to read-only.

smh

Hi, why do you want to bother about the rights to specific fields. Dont you think its buying headache, well frankly i think it is. You could always can have it done by enabling/disabling the controls on ur form and limit the user. Well, give it a try...all the best...vijay