The 60sec timeout in Access is easy to get rid off, just right click in the design view of the query and set "ODBC-Timeout" to 0 instead of 60.
Though that 30sec limit is hard one to crack, I have the problem using ASP-scripts and doing queries in SQL as well.
Of course one should use indexes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.