i have a saved A pass-thru query calling an SQL-Server stored procedure with a parameter. it works purrrrrfectly when i set up the pass-thru manually using A's query designer interface.

the "SQL" in the passthru is simple
myStoredProcName 1234
where 1234 is the parameter (an Access long).

i now need to change the parameter from code.

anything i try* reduces the "SQL" to
and then (obviously) gives me an error saying i've got to SELECT something.



i tried deleting the existing querydef and CreateQueryDef
i tried modifying the .SQL of the existing querydef