Pass through query

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

Guest

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
 
I am new to SQL Pass Through Queries. If you could please let me know how I
can run the query through SQL Query Analyzer it would be great help

Thanks
 
My answer assumes you have the SQL Server Client Tools installed on your PC.
One of these tools is the SQL Query Analayzer which is much like the query
design window (SQL View) in Access.

What I was getting at was that are you certain you should be returning
records?
 
Yes, the query should be returning records. This has been tested. We have
created Crystal reports based on the same stored procedure as well. Any idea
why the records don't show up in Access query. Appreciate any help.

Thanks in advance
 
Are you sending any arguments/parameters to the stored procedure? Is the
datasource the same for this pass-through? Do you have access to the SQL
Query Analyzer to test the sp? Can you check again to make sure your PT is
set to return records?

I have never experienced an issue where the PT didn't exactly duplicate the
results from the SQL Query analyzer.
 
Back
Top