Updating an Access table from a SQL server table transaction
My goal is to write an update trigger within a SQL server DB table. The function of this trigger is to update an Access database table with the same information that is being updated in the SQL server.
Is thi开发者_开发技巧s even possible?
You have to use Linked Server to create communication between sql server instance and access database...
or make use of OPENROWSET function
精彩评论