We use an Access2000 database as a front end to combine data from
several different datasources (Sybase - SQL Server - Access - etc.)
We have a DTS job that processes some of the SQL data that we use.

The only problem is that someone (usually me) has to execute it when
things have changed and we can't wait for the scheduled time. Can
someone give me some instruction for how to execute these remotely -
possibly from a command button in Access?

Thanks A TON in advance...

A few ways are given here

Execution
(http://www.sqldts.com/Default.aspx?104)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ray" <ray_park (AT) bellsouth (DOT) net> wrote