Returning Records from SQL 7.0 Stored Procedure in Access 2000 Pro

G

Guest

I am having trouble returning records from a complex stored procedure (my
definition of a complex SP is one that uses more than a single select
statement). The SP should be returning the results set for a gaussian curve
that I am building into a temp table. Unfortunatly from Access I get a
message along the lines of: "The stored procedure executed successfully, but
did not return any records". I have a few other SPs that only have a single
Select statement and they return just fine. Any help or suggestions would be
greatly appreciated.

Thanks
 
G

Guest

Well, it trucated my subject line so here is a bit more info. The application
is an MS Access 2000 Project (.adp) with an SQL 7.0 backend.
 

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

Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
Execute SQL Stored Proc from Access 1
Stored Procedure "...did not return records" Error in Access 2007 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
return data from stored procedure 1
Access 2000 ADO Recordset from Stored Procedure 3
Code for inserting rows from a stored procedure into a Access Table 4
How do I create an MS SQL Server stored procedure from MS Access V 1

Top