Maximum Number of Joins

[_stef_]

It seems that the maximum number of LEFT / INNER JOINS is limited to 8 ? Can somebody confirm / explain this ?

 

[Joe4]

I moved your thread to a new post. It is best to post your new questions to a new thread instead of tacking it on to real old threads. Most people will not see it as an unanswered question.

It may depend on which version of Access you are using, and whether or not you are using any multi-layered fields, but it looks like the limit is typically 16: Access 2007 specifications - Access - Office.com