开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜