execute a stored job through MS ACCESS 2000

From: Oskar (o_vaia@hotmail.com)
Date: 08/31/02


From: "Oskar" <o_vaia@hotmail.com>
Date: Sat, 31 Aug 2002 10:00:37 +0200


hi,

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
Catalog=salesDB;Integrated Security=SSPI;"
conn.execute "EXEC msdb.dbo.sp_start_job @job_name = 'salesstat'"
conn.close
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
Oskar
(sorry, for my english!)