=> Query in SQL Server not recognised by Access Project

[Rhonda Fischer]

Hello,

Perhaps it's not the permissions I have granted on
the 'stored proceedures'.
The error message I receive when I click on a drop down
box with a Row
source of: spLoadedStatusCodes

--------------------------------------------------------
Alter Procedure spLoadedStatusCodes
As
SELECT * FROM StatusCodes WHERE Status
LIKE "Loaded%"
return
--------------------------------------------------------
is Error Message: "The record source 'spLoadedStatusCodes'
specified on this form
does not exist"

I'm not sure why the stored proceedures in SQL Server are
not recognised in the MS
Access Project. The queries automatically display when I
created the project attached
to an existing database. I didn't put the proceedures in
the Access app they just appeared
although I notice the proceedure in the SQL Server is a
CREATE query while the one
in the Access Project seems to be an ALTER, not sure why
this is so?

Any ideas would be terrific.

Thank you very much
Rhonda