SQL Trigger and Microsoft Access

  • Thread starter Thread starter Anne
  • Start date Start date
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
 
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
 
Back
Top