stored procedure executed successfully but did not return records

[weldon scott]

I have an Access 2000 .adp front end using an SQL server backend. forms
connect routinely to stored procedures via their recordsource property and
work perfectly. I have however built some complex stored procedures to
emulate crosstab queries with the final line being the execution of a
@string variable containing a constructed select statement. The stored
procedures work perfectly in the Query Analyser, but when I attempt to run
them from the front end I get the message 'Stored procedure executed
successfully but did not return records', after clicking OK it returns to
the previous view, not to the display of an empty recordset.
I have connected delphi clients to the database using ado and the stored
procedures have worked fine there also.

Can anyone offer a solution the deadline for submission of the project is
imminent

[Bob Pfeiff [MS]]

At the beginning of the stored procedure, add SET NOCOUNT ON, this
suppresses rows affected messages which Access sees as the result of the
stored proc.

--
Bob
Microsoft Consulting Services
------
This posting is provided AS IS with no warranties, and confers no rights.