i would like to execute a stored job through MS ACCESS 2000 from a
client-pc, who is not member of the sysadmin-roule.
the job execute a DTS package.
here my code in VBA:
dim conn as ADODB.connection
set conn = new ADODB.connection
conn.open "Provider=SQLOLEDB;Data Source=SQLSERVER;Initial
set conn = nothing
when i try to run the makro then it'll not function.
on the server is running SQL Server 2000 with SP2.
the server use windows authentication.
what must i do to run the job with a non sysadmin-member-account?
what is the PROXY ACCOUNT and how is it to use?
thx and bye
(sorry, for my english!)