Any time I make a query against an Access database it takes a long time to load

 

Description:

Any time I make a query against an Access database it takes a long time to load the results.
 

Solution:

1. You may be overloading Access. Access is designed for desktop and small Internet applications. Test it locally. If it is fine on your system then your site traffic is overloading it. Try upgrading to SQL Server 7.0.

2. If you are using Access to connect to your database, you may want to look at these tips: http://msdn.microsoft.com/library/psdk/iisref/iiwadata.htm

3. Check your SQL syntax to be sure your JOINS and NESTED QUERIES are correct.

Back