Problem in Access with Stored Procedure containing Temp Table

[Matt Weaver]

I'm trying to return rows from SQL Server through a stored procedure
which creates a temporary table. When I open the SP in an Access .adp,
it returns no rows. I have no problems with the SP in Query Analyzer,
using the login used in the .adp. In fact, I've used SQL Profiler to
capture what Access is sending to SQL Server, and when I execute that
code in QA, I get the rows I expect to see. If I delete the code which
creates the temporary table, the SP is properly invoked on the Access
side. Is there something with Access that prevents me from executing SPs
which create temp tables?

I was able to get around the problem by using a table-valued function,
but I'm wondering what was the issue with the temp table.

Thanks!
Matt