"cannot open any more databases"

[Idjit]

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!

 

[Jack Cowley]

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