I have a stored procedure that requires one parameter and creates some temporary tables. It runs perfectly in query analizer but when I try it from a click event in Access (ADP) it tells me that one of the temporary tables can not be found. I also looked into using DOCMD.openstoredprocedure but it does not provide a maner for sending the parameter.

The code im using is simple;

dim strMyID as integer
strMyID = me.SS_ID.value 'This is from a field in my form.
docmd.RUNSQL "exec spCALC " & strMyID

:(

Thanks,
Jesse

__________________
Thanks,
Jesse