Question on Slow Speed on Access to run SQL

By Hunterzh ·
I've designed an Access project, by Access + SQL Server 2000. In the project, I've written several stored procedures. But one problem is: when I try to run the stored procedure in Query Analyzer, the speed is quite fast; while when trying to run the SQL query in Access, the speed is very slow. What might be the reason? How can I increase the speed of SQL in Access project?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums