ACC2000: Output of Stored Procedure Truncated in Access Client/Server (232562)
The information in this article applies to:
This article was previously published under Q232562 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
When you run certain stored procedures from a Microsoft Access project, the output of the procedure is truncated in Datasheet view. If you run the same procedure from one of the SQL Server Client Tools, all rows are returned as expected.
CAUSE
If a stored procedure returns multiple result sets in its output, an Access project returns only the first result set to Datasheet view. The user interface in an Access project is not designed to return multiple result sets.
RESOLUTION
Use alternate tools to run stored procedures that return multiple result sets, such as SQL Server Query Analyzer or OSQL.
REFERENCES
For more information about rules, SQL Server Query Analyzer, or OSQL, refer to SQL Server 7.0 Books Online, which is available for download from the following Microsoft Web site:
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbdownload KbClientServer kbprb KB232562 |
---|
|