Access 2003 reporting problem

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.

Heine Ferreira

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!