"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

Quote:

>From time to time this produces Error 3258 "The SQL statement could

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.

Michael Scott <michael.scott@dsl.pipex.comwrote in
news:1194516109.158722.192940@y27g2000pre.googlegr oups.com:

Quote:

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
>

Quote:

>>From time to time this produces Error 3258 "The SQL statement could

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.
>

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

When you test the querydef, Access parses the SQL. You just need an

Quote:

error handler that does a resume next on error 3258.

Thanks 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.

"Ambiguous outer joins" error when looping through querydefs

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

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

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about