Hi All,
I created triggers in sql server database to audit table changes insert/update/delete. But I am getting the following error while updating a record through client access 2000:
"You can't update the record because another user or application deleted it or changed the value of its primary key"
Please let me know if I should not use triggers and insert audit changes through form.