Stored Precedure: cannot create one!

I'm trying to use Access 2007 as a front end to visually create Stored Procedures, Tables, and Views in the SQL Server 2005 "back end" database.
I can do everything except create Stored Procedures. I receive an Error Message , it says something like this:

ADO Error
the name of the schema "SQL2005_712118_aes_user" not exist or haven't got the permission.

Would you help me?
I like to use Access 2007 as a front end, because I used it for a long time and I don't want to use the Manager Console.

Thanks, in advance.
RicardoArmando

 

Hi Bruce:
I don't know how to use the dbo schema with Access 2007 and SQL2005. Untill few days ago I used another server (SQLServer 2000 at Interland, and Access 2003) and and everything worked fine ...

 

More data:

At the Stored Procedure property tab in Access 2007, the owner is grey, and set as "SQL2005_712118_aes_user"; and I can't change it to dbo ...

Thanks ... I love the visual interface of Access 2007, I don't want to write code for the Stored Procedures ... but it seems there is no other way but change it for MMC!

Really thanks
RicardoArmando

 

Store procedure for additonal fields add to ASPNETDB.MDF table in the database,like adding additional field like lastname, country, phone N0 etc., how do we configure it to show in the database of ASPNETDB.MDF