I wrote a stored procedure in SQL Server 2000 that does the following at the end of the stored procedure: select * from #tblTemp
. When I try to design a report in Access it doesn't pick up any fields at design time.
What can I do about this? It works with Crystal Reports and VB6, but my company uses Access for a development environment.