When you use an SQL statement, VB or Access must examine EVERY record in the database to check if it meets the criteria. On a large database, this is time consuming. Try copying records, using your indexes, to a "temporary" database and then performing your SQL query on that...
I am writing a "menuing" program that uses the "shell" command to launch apps. I want to know what the latest technique is for determining when the app is exited. I used to be able to do this by launching to app via a batch file that erased a blank file when the program...
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.