|Any time I make a query against an Access database it takes a long time to load the results.|
|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.