Very Computer

Is it possible for a trigger or stored procedure to update a remote table
via ODBC or such like.  e.g. A stored procedure that inserts a row into an
access database.

Probably not, but worth a try !.

San

Sean - if you write your own XP or use a linked-server then yes.

Quote:> Is it possible for a trigger or stored procedure to update a remote table
> via ODBC or such like.  e.g. A stored procedure that inserts a row into an
> access database.

> Probably not, but worth a try !.

> San

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (412 entries) see

http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk