Access forms and SQL triggers

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I use Access forms as a front end to a SQL Server
database. The SQL tables are linked into Access. There
are Insert and Update triggers in SQL. When I execute an
Insert or Update statement in Access the triggers work.
But when I do an insert or update using the form the
triggers do not fire. Any ideas about that? Thanks
 
Ken said:
I use Access forms as a front end to a SQL Server
database. The SQL tables are linked into Access. There
are Insert and Update triggers in SQL. When I execute an
Insert or Update statement in Access the triggers work.
But when I do an insert or update using the form the
triggers do not fire. Any ideas about that? Thanks
Click to expand...

I'm fairly certain you are incorrect about that. Perhaps you aren't
immediately seeing the results of the triggers, but they are almost
certainly firing. The only way to make them NOT fire would be to execute a
statement to drop them, perform your insert or update and then execute a
statement to put them back.
 
Thanks for the response. You are correct. I can see in
SQL that the triggers are firing. I was just not seeing
the refreshed data in the form. Clicking Records,
Refresh shows the results of the triggers. Thanks
 
Back
Top