I have lookup tables in my database. The client wants to ensure that usres can not make any changes to the tables while they do the dataentry using ACCESS (adp) front end which is connected to sql 2005 database.
They do not want to use form validation however they asked for using triggers to validate and generate error message if anyone wants to delete or update a value but it should allow to insert new values.
Lets say I have a lookup table AgeGroup with columns: ID, AgeGroup
how can I right the trigger as well as display error message?
Thanks in advance