I've a problem when I use an INSERT query in Access to put some data on MSSQL through a linked table
(simple: "INSERT INTO remote_table ( column1,column2) SELECT col1,col2 FROM local_table"). I found that the records are added one-by-one so my trigger on remote_table executes many times with table one record in [inserted] table. My question is there any way to make Access move all record at once...

Ignas