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?
