Stored procedure did not return any rows (1 Viewer)

[hcoded]

I created a project and connected to my SQL Server database. In this database I haev a stored proc that returns rows from a table. When I run the stored proc in SQL server it returns rows. When I run it in Query Analyzer it returns rows. When I run it in Access, it says "The Stored Procedure executed successfully but did not return any records."

I know 100% that the parameters are the same being passed in. I even removed the parameters and hardcode the value for test and the same thing happens.

Now my other Stored Procs run fine, just not this one. Anyone have an idea why I wouldnt get anything back in Access but I do through other means?

Thanks in advance.