pass throught query by parameter

[iccsi]

I use pass throught query against SQL server backend database.
I always to use MS Access to build SQL string like

EXEC MyStroedProcedure Param1, Param2


I just wonder that can I use pass throught query like other query pass
by parameters instead of build the SQL string.


Your information and help is great appreciated,



iccsi

 

[John W. Vinson]

I just wonder that can I use pass throught query like other query pass
by parameters instead of build the SQL string.

No, since SQL has no way to see the form or the parameter. You must build it
into the SQL string.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com