Apr 4, 2003 #1 Danman75 Programmer Joined Apr 1, 2003 Messages 16 Location US Is there a way to use a global temporary table as the record source in an access report? When I try, it tells me that the table doesn't exist.
Is there a way to use a global temporary table as the record source in an access report? When I try, it tells me that the table doesn't exist.
Apr 4, 2003 #2 SQLSister Programmer Joined Jun 18, 2002 Messages 7,292 Location US You could set up a passthough query as the source which calls a stored procedure that uses the global temp table Upvote 0 Downvote
You could set up a passthough query as the source which calls a stored procedure that uses the global temp table
Apr 4, 2003 Thread starter #3 Danman75 Programmer Joined Apr 1, 2003 Messages 16 Location US Thanks! I'll give it a try. Upvote 0 Downvote