I am using the following trigger to update a date field:
CREATE TRIGGER trHdwr_TranPert_IU ON dbo.tblHdwr_TranPert
FOR INSERT, UPDATE
SET tblHdwr_TranPert.dtm_TranPert_Updated = getdate()
FROM tblHdwr_TranPert, inserted
WHERE tblHdwr_TranPert.id_TranPert = inserted.id_TranPert
I am using MS Access to update the tables (view).
When I edit a record, move to the next record, and then move back to the
original record to edit it again, I get the following dialog box in (MS
"The data has been changed. Another user edited this record and saved the
changes before you attempted to save changes. Re-edit the record."
When I close the dialog box, I can then make changes. Also, I am using the
same trigger for multiple tables, and except for this one table, they all
Thanks in advance, Steven