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?
Best Answer
Yes. The Access frontend will not suppress the SQL procedures.