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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 ADP Write Conflicts with SQL server triggers 2
Access forms and SQL triggers 2
How do I set up a trigger in Access 2007? 2
SELECT @@IDENTITY in A2010 with Triggers 6
>> sql trigger 9
TRIGGER a VIEW with SQL for a LINKED SERVER (ACCESS DB) 6
Write conflict on SQL 2000 ODBC linked table 7
Error 7874 6

Back
Top