MS Access Passthrough Query keeps asking for DNS but others don't

[buzz43uk]

Hi

May have found the issue but not the solution.

The query below is a passthrough to Intersystems Cache database via ODBC

"SELECT * FROM wmhISTORYdETAIL" runs as a passthrough without asking for the DNS (no issue)

but

'SELECT WMHistoryDetail.HistDate, WMHistoryDetail.HistMovDate, WMHistoryDetail.HistMovType, WMHistoryDetail.HistLocnFrom, WMHistoryDetail.HistLocnTo,WMHistoryDetail.HistHMNumber from SQLUser.WMHistoryDetail'

always asks for the DNS but both are linked to a table that has the password saved.

Any Ideas please?

Rob

[#2]

This has nothing to do with the SQL of the query. Open both queries in design and compare the connection strings in the Connect-Property of the queries. Copy the one from the working query to the other.