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