Maximum SQL size

Does anybody know the maximum number of JOINs that you can have in a VBA SQL query, as I have just reached an error message saying the query is too complex.

Also, whilst on the subject any other know limitations would be appreciated ( or a URL to them).

Thanks ,
John
"I may appear stupid, but I'm merely incompetent."

check this out, it's article # q103429 from MS's knowledge base.

You must have a very lengthy query...???

http://search.support.microsoft.com/kb/c.asp?fr=0&SD=GN&LN=EN-US

anchor's aren't working for some reason....

I have recieved this error before but it wasn't because it was too complex, rather I had a mistake in my query string that was confusing access....

images/icons/smile.gif