India@ccess  

HomeAbout 
 UsServicesOrder NowSupportClientsSite MapContact Us

Tel Search
Sign Up New Users Click Here
Current Users Login

NT Hosting  Linux Hosting Reseller Dedicated  Sign Up Now Email Us Home


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