1

I have a simple yet undocumented (or I could not find the documentation to solve my uneasiness) question, I hope I have come to the right place:

I am using MS Access to act as a poor front end for SQL Server. In this Access file I have some linked tables that will undergo some editing at various points by some users, be it via forms or directly accessing the table in spreadsheet view (I advised against this but, well...).

My concern is: the server has some procedures set on this table that are coded to trigger on insert/update. Will they be triggered when doing these edits via Access front end?

Improve this question
2
  • 2
    Yes, they will; the triggers shouldn't be aware of what causes the inserts/updates (except, maybe, for restore operations). Triggers care only about inserts/updates happening. And most probably, that's exactly what you actually want to happen.
    – joanolo
    Commented Jan 28, 2017 at 12:14
  • That's great news. Thanks @joanolo . I assume this should be the default behaviour for every DB Management System?
    – Feillen
    Commented Jan 30, 2017 at 12:26

1 Answer 1

Reset to default
0

Yes. The Access frontend will not suppress the SQL procedures.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.