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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass through query 5
Access pass-through query to Oracle 10g stored procedure - results 1
Pass Through Query - not returning rows 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
stored procedure query 4
Question on Pass-through Query 4
connect to multiple odbc in pass-through query 1

Back
Top