Pass Through query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I posted the following message in error to access.reports. Sorry about that.

I am trying to create a database whose record source is a SQL stored
procedure. I have created a SQL Pass-Through query to retrieve the records:

EXEC CR_ORDERVIEW2
where CR_ORDERVIEW2 is the stored procedure.

When I run the query all I see is the fields that make up the stored
procedure, but the data is not there the Returns Records property has been
set to Yes.

Any help would be appreciated.

Thanks
 
Apparently you expect to see records? What happens when you enter the same
in the SQL Query Analyzer?
 
Back
Top