I have a trigger in SQL which fires a stored procedure whenever there is an update in the SQL table. The Stored procedure does the following: 1. Establish a connection to an MS Access db. via jet.OLEDB method. 2. Insert a recored to a table.
Here is the issue that I'm having:
Wher the trigger fires the stored proceduer, nither of them generate any error messages, but no record has been inserted to the Access table!?! However, when I run them induvidually, they seemed to be ok.
I'm looking for another ways to do the job, and I would like to know how to do it using ADO.
Thanks.