Hi, I have an ACCESS DB (.mdb) generate by an Automation. Now, I would like to: 1/ Copy all datas from the ACCESS DB in my SQL Database. I using DTS. All are working. But, after copying, I would like at each time a new record is inserted in the ACCESS DB, I copy this Record in my SQL DATABASE (synchronize the SQL DATABASE). For this, I create LINKED SERVERS for the ACCESS DB (Named LOG). In my SQL DATABASE, I create a VIEW that read one TABLE from LOG (linked ACCESS DB). Now, I would like to create a TRIGGER from this VIEW for retrieve each INSERT and copy this insert in my SQL DATABASE. Please find the CODE below : CREATE TRIGGER trgLog on [dbo].[VIEW_LOG] INSTEAD OF INSERT AS BEGIN declare @Log_Date datetime, @Log_Input smallint, @Log_Level smallint, @Log_Milliseconds smallint, @Log_Output smallint, @Log_Panel smallint, @Log_Response smallint, @Log_Status smallint set @Log_Date ='05/07/2004 00:00:00' set @Log_Input =1 set @Log_Level =1 set @Log_Milliseconds =1 set @Log_Output =1 set @Log_Panel =1 set @Log_Response =1 set @Log_Status =1 exec InsertLog @Log_Date,@Log_Input, @Log_Level,@Log_Milliseconds, @Log_Output,@Log_Panel, @Log_Response,@Log_Status END So in this code I Insert a test message after hat a select "insert". But when I refresh my SQL DATABASE, I see nothing whereas I the ACCESS DATABASE the AUTOMATION insert record. Can You Help me about that ? Best Regards youssef