I don't know why some stored procedures run more slowly when I call them from Access rather than SQL Management Studio.
I have setup a Data Source using the SQL Server driver.
As an aside, I am having the same problem in Asp.Net
Does anyone have any ideas?