SQL Trigger and Microsoft Access

A

Anne

I have an SQL Trigger which update data in a table.
The table is linked in Access
When updating data in Access, if the trigger is fired, I got the following message:
"This record has been changed by another user since you started editing it."

How can I update the data anyway, with the result of the trigger?

Does anyone knows what to do?

Thank you for your help.

Anne
 
A

Alex Dybenko

Hi,
Depends on what you have in your table and trigger, but common reasons that
you dont have timestamp field (just add it) or you making some data
manipulation with same table in trigger. Probably you can give more details
--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
 
Top