passthrough flag? on querydef

[jerryk]

Hi,

Does anyone know the best way to determine if a query is a passthrough? I
need to write a routine that lets me update the ODBC Connection string for
all my passthrough queries.

 

[Rick Brandt]

Hi,

Does anyone know the best way to determine if a query is a
passthrough? I need to write a routine that lets me update the ODBC
Connection string for all my passthrough queries.

If the Connect property is not null then it's a passthrough.

 

[jerryk]

Thanks. However, I don't think this is sufficent test since my code could
set .Connect to ""

I did a bit of testing and I believe that .Type =112 is passthrough.

jerry

 

[Douglas J. Steele]

If Len(qdfObject.Connect & vbNullString) > 0 Then
' it's a pass-through query
Else
' it's not a pass-through query
End If