So are you trying to execute a stored procedure from Access?  That would typically be the case where you pass parameters to SQL Server.  We typically define an ADODB connection, and define the ADODB.Command and then in VBA we define the command text as something like "EXEC StoredProcedureName Parameter1 Parameter2 ..."  In that appraoch you get an ADO recordset returned which you must then process.  If you aren't comfortable with ADO, then the pass-through query is an easier method as long as you aren't trying to return large recordsets.  Hope this helps a bit.