How do I send parameters to MS SQL Server with Access 2007 adp?

I have seen many posts about creating a pass through query. MSAccess 2007 .adp does not have an option for a pass through query. So I tried several examples of running stored procedures. I only come up with errors, mostly ‘Object Variables using the examples verbatim. I have an HP 64bit Quad core laptop. Any ideas????
Thanks
Don