SQL Server Store Procedure returning data from a temp table or a table variable to Access

[anasser]

I am having a problem getting data from a store procedure on an sql
server from a temp table. I have to return the data from a table
created within the store procedue at run time due to some joins and
manipulation of the data at run time. when my pass-through query calls
this store procedure, I cannot retrieve the data from the temp table.
Is there a way to do this?

Thanks, and I appretiate any ideas and approaches...

 

[Nery Gonzalez]

Well, that depends on what you are already doing. Just make sure you are
creating a temp table available to the consecuent pass-through query.
Because you can declare (create) a temp table with local access (existing
only during the SP which created it) with the # sign and a temp table with
global access (until you delete it) with the ## sign.