I have a MS Access front end from which I do a insert into a linked table on SQL server. Basically I get the data from the frontend ( excel template) and store it on a access table.
I insert this data into a sql table A. But there is a INSERT trigger on this Table A which copies data to some other table B in SQL server.
Will the trigger be fired only once? Users are reporting some performance issues with bulk upload.
How can i improve the performance?