Unanswered: modify parameter in pass-through query
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
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
currently using SS 2008R2