I'm trying to use a query to pull together information from several other queries. When I try to run it, I get the error message "cannot open any more databases". Any ideas why this happening (I assume there're too many subqueries?) and what the limit for open databases is?

Thanks!

Search Help for Limits, Program to find what the limits are....