'SELECT Clause Does Not Return Rowset From Sp'

I have sp20, simplified, as:





ALTER PROCEDURE dbo.sp20 (@CustomerID int, @aDate as datetime) AS





SELECT Customers.* INTO #EndResult1 FROM Customers WHERE Customers.CustomerID >= @CustomerID





SELECT Orders.* INTO #EndResult2 FROM Orders Where Orders.[TakenDate] >= @aDate





SELECT #EndResult1.*, #EndResult2.*


FROM #EndResult1 INNER JOIN #EndResult2 ON #EndResult1.CustomerID = #EndResult2.CustomerID





This works fine in EM.





When I try to execute it from MS Access ADP Project I get





'Stored Procedure excuted succesfully, but did not return any records'





Although, in EM it returns the right number of records.





Thank you in advance - Rehman