Executing a stored procedure through a command button

[perfectchaoss]

Hi,
I am trying to execute a stored procedure in the onclick event of a command button. I already have the stored procedure working, i just need to be able to execute it. Here is what i have so far..
RunDTS is the name of my stored procedure.

Private Sub ImportNewItems_Click()
DoCmd.OpenStoredProcedure "RunDTS"
End Sub

(this returns the error: access cant find the object "RunDTS&quot
The procedure returns no parameters, it just has to execute.
any ideas?

 

[Eupher]

Try this...

Private Sub ImportNewItems_Click()
     Call RunDTS()
End Sub

Ken S.

 

[perfectchaoss]

Ken,
Thanks for the quick reply, it gave me the message sub or function not defined. I may not have been clear enough in my original post.

The Stored procedure is on SQL enterprise manager and the access database is on a client PC.

Joe