You can have an impact on how queries are evaluated by Jet by separating them and nesting them.
If possible could you give an example of seperting and nesting queries so Jet sends only the nested query to the server and not the entire thing (compiling all into on single query)?
Thanks for expanding on querydefs - it was one of those verbage issues where I was pretty sure what you were talking about but not entirely... I must say that while I did quite a bit of reading last night on querydefs and the compilation, loading, and processing differences between stored queries and dynamic SQL your two paragraphs above regarding the use of, and differences between dynamic and querydefs was much easier to read and understand... thank you for taking the time to detail the difference between the two methods of returning recordsets.
In addition, I'm sure someone with your talents is extremely busy but I sincerely hope you are still working on your book as it is apparent you have a gift for making difficult concepts easy to interprit and understand...
Thanks Again,
Kevin