June 24, 2008 at 11:37 am
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?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy