SQL Server >> Moving data from SQL Server to Access
Could anyone please offer advice on the following:
I have a table in a SQL Server database, that I would like to put a
trigger on. When an Insert is ran on the table, I would like to also
run an insert on an Access database. The Access database is not on the
same server, but is on a networked drive.
Could someone please indicate how I would connect to Access within a
trigger?
> Could anyone please offer advice on the following:
>
> I have a table in a SQL Server database, that I would like to put a
> trigger on. When an Insert is ran on the table, I would like to also
> run an insert on an Access database. The Access database is not on the
> same server, but is on a networked drive.
>
> Could someone please indicate how I would connect to Access within a
> trigger?
>
> Thanks.
>