The query builder uses ANSI 89 SQL Syntax. So, it's join syntax will be a problem for any outer joins and for other joins, the syntax is deprecated. If you write queries directly rather than using the builder, it should work ok.
It's about time you abandon VB5.