"Ambiguous outer joins" error when looping through querydefs

This is driving me nuts. Can anyone help?

I have a program which searches for and analyses Access databases
across a corporate network. At one point in the code I am looping
quickly through all the querydefs in the target database to give an
idea of what we're dealing with:

For Each qdf In dbsDiscoveredDatabase.QueryDefs
If Left(qry.Connect, 4) = "ODBC" Then
mblnODBC = True
End If
Next qdf
not be executed because it contains ambiguous outer joins". I know
what this error message usually means, and how to rectify it, but in
this instance it is baffling me. Am I somehow trying to run the query
by looking at its Connect property?

This happens very infrequently, but I have a feeling it might be
limited to MDE files. Is that a possibility?

Thanks in advance for any help and suggextions.

re: "Ambiguous outer joins" error when looping through querydefs

Michael Scott <michael.scott@dsl.pipex.comwrote in
news:1194516109.158722.192940@y27g2000pre.googlegr oups.com:
When you test the querydef, Access parses the SQL. You just need an
error handler that does a resume next on error 3258.





--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

re: "Ambiguous outer joins" error when looping through querydefs

When you test the querydef, Access parses the SQL. You just need anThanks very much! I had already added code to do just that, as a
workaround, but it's good to know that that is the solution.